SQL writing queries for authentication code example

Example: create login sql server

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