What is the syntax for creating new login on the SQL server?

Options
- USE LOGIN login_id WITH PASSWORD password
- CREATE LOGIN login_id WITH USE password
- CREATE LOGIN login_id USE password
- CREATE LOGIN login_id WITH PASSWORD password

CORRECT ANSWER : CREATE LOGIN login_id WITH PASSWORD password

Discussion Board
SQL Server Login

The CREATE LOGIN statement creates an identity used to connect to a SQL Server instance. The Login is then mapped to a database user (so before creating a user in SQL Server, you must first create a Login).
Syntax: CREATE LOGIN login_id WITH PASSWORD password

Prajakta Pandit 03-10-2017 04:17 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲