为什么会显示“Incorrect syntax near 'L2'.”create login L2 with password123,sp_addsrvrol
为什么会显示“Incorrect syntax near 'L2'.”
create login L2 with password='123',
sp_addsrvrolemember 'L2','dbcreator'
[最优解释]
create login L2 with password='123'
go
sp_addsrvrolemember 'L2','dbcreator'
[其他解释]
exec exec
