sql - CREATE PROCEDURE 权限在数据库 'master' 中被拒绝

Question

我在sql server中创建过程，我的代码如下

CREATE PROCEDURE GetRegistrationId
( 
  @MaxId INT OUTPUT 
)
AS
BEGIN
  SELECT @MaxId = MAX(UserId)  FROM tblRegistration;
return;
END

但它给出错误提示

CREATE PROCEDURE permission denied in database 'master'.

Answer 1

试试这个:

USE <Your Database Name>
GO

CREATE PROCEDURE GetRegistrationId(@MaxId INT OUTPUT)
AS
BEGIN
  SELECT @MaxId=MAX(UserId)  FROM tblRegistration;
RETURN;
END

或

Select "Your Database Name" from Toolbar (SQL Editor) and then Execute the procedure