이슈
create proc you_cannot_see with encryption
@no char(20),
@name nvarchar(20)
as
print @name
go
Msg 102, Level 15, State 1, Procedure you_cannot_see, Line 2
Incorrect syntax near '@no'.
Msg 137, Level 15, State 2, Procedure you_cannot_see, Line 5
Must declare the scalar variable "@name".
해결책
with encryption 옵션의 위치를 변경해주면 됩니다.
create proc you_cannot_see
@no char(20),
@name nvarchar(20) with encryption
as
print @name
go
execute sp_helptext you_cannot_see;