SQL Server/T-SQL Tutorial/System Functions/sp addlogin
A statement that creates a new SQL Server login ID
<source lang="sql">
EXEC sp_AddLogin JohnDoe, pw8806</source>
Creates a new SQL Server login and then maps that login to a new database user
<source lang="sql">
USE Master GO sp_addlogin "Paul",
--USE AdventureWorks2000
GO sp_grantdbaccess "Paul", SQL Server 2000 Windows login:</source>