加密已存在的存储过程时出错

I am trying to encrypt the stored procedure as below but its giving error.Please help me

我试图加密存储过程如下,但它给出错误。请帮助我

alter procedure spo1
with encryption
@ID int,  
@NAME nvarchar(60)
as  
begin  
  insert into metal1 (id,name) values (@ID,@NAME)  
end

1 个解决方案

#1

You Wrote wrong Syntax Please Check Below code..

你写错了语法请检查下面的代码..

  alter procedure spo1
     @ID int,
    @NAME nvarchar(60) 
     with encryption // Put With Encryption Here...
    as
    begin
    insert into metal1 (id,name) values (@ID,@NAME)
    end