How to set password for the sqlserver user by query

alter login username or userid with password='Give password inside single quote',check_policy=off