sql server create new user login code example

Example 1: create login sql server

CREATE LOGIN <login_name> WITH PASSWORD = '<enterStrongPasswordHere>';
GO

Example 2: create user sql server

/*You can also create a login using the T-SQL command.*/
CREATE LOGIN MyLogin WITH PASSWORD = '123';