Creating new SQL Server Login programmatically

Declare @LoginName nvarchar(100)
Declare @Password nvarchar(100)
Declare @SQL nvarchar(max)
Begin
    Set @LoginName = 'TestAdmin'
    Set @Password = 'pass@word1'
    -- Create user
    Set @SQL = 'Create Login ' + @LoginName + ' with Password = ''' + @Password + ''''
    EXEC sp_executesql @SQL
    -- Adding user to sysadmin role
    EXEC sp_addsrvrolemember @LoginName, 'sysadmin'
    -- This will give you list of SQL Users
    select * from sys.sql_logins
End