IT Questions and Answers :)

Friday, December 22, 2017

If you want to create a new login on SQL Server, what is the proper syntax?

If you want to create a new login on SQL Server, what is the proper syntax?

  • CREATE LOGIN login_id WITH PASSWORD = password
  • CREATE LOGIN login_id WITH USE = password
  • CREATE LOGIN login_id USE = password
  • USE LOGIN login_id WITH PASSWORD = password 

 
If you want to create a new login on SQL Server, what is the proper syntax?

EXPLANATION

Somebody on the Microsoft team decided that this syntax – create a login with this password – made sense. Even if it's arbitrary, you can't say it isn't intuitive.
https://msdn.microsoft.com/en-us/library/ms189751.aspx
Share:

Popular Posts

Blog Archive