While creating some scripts in a test environment to create logins and add members I noticed that ALTER ROLE has been upgrade with the ADD MEMBER option. this option replaces the stored procedure sp_addrolemember used in SQL 2008 R2 and previous versions.
The syntax for ALTER ROLE has now been upgraded with the ADD MEMBER option:
For instance on a SQL Server 2008 R2 granting logins to a Database would be like this:
With SQL 2012 or 2014 you can now create logins with the following script:
On the MSDN library site the SQL Server 2012 documentation for sp_addrolemember warns that this will be phased out in a future version