set @Sql=N' ALTER LOGIN ['+@LoginName +N'] WITH PASSWORD =' +N''''+@Password+N''''
exec(@Sql)
set @Sql=N' CREATE USER ['+@UserName +N'] FOR LOGIN [' +@LoginName+N']'
exec(@Sql)
我在sql2005增中了用户名和登录名“ set @Sql=N' ALTER LOGIN ['+@LoginName +N'] WITH PASSWORD =' +N''''+@Password+N'''' exec(@Sql) set @Sql=N' CREATE USER ['+@UserName +N'] FOR LOGIN [' +@LoginName+N']' exec(@Sql) 如果用select user_name()就可以显示出用户名,但是写什么sql语句可以显示登录名?就是l