SQL

create user sql server

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

ms sql create user

USE master;
CREATE LOGIN [Hiru] WITH PASSWORD = 'pwd';
USE mydb;
CREATE USER [Hiru] FOR LOGIN [Hiru];