Sqlserver脚本创建登录名密码

use table1
GO
create login abc with password='123', default_database=table1; 
GO
create user abc for login abc with default_schema=dbo;
GO
exec sp_addrolemember 'db_owner', 'abc';

 表名：table1,用户名：abc,密码：123