Question:
What is the syntax for creating new login on the SQL sevrer?

Option A):
CREATE LOGIN login_id USE password
Option B):
USE LOGIN login_id WITH PASSWORD password
Option C):
CREATE LOGIN login_id WITH USE password
Option D):
CREATE LOGIN login_id WITH PASSWORD password

Correct Answer is Option D):
CREATE LOGIN login_id WITH PASSWORD password