CREATE LOGIN [LoginName] WITH PASSWORD = ‘password‘, DEFAULT_DATABASE=[DataBaseName], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
Tested on: SQLServer 2017
CREATE LOGIN [LoginName] WITH PASSWORD = ‘password‘, DEFAULT_DATABASE=[DataBaseName], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
Tested on: SQLServer 2017