CREATE PROCEDURE QueryRightInfo
@sRightID varchar(500)
ASvar sqlstr varchar(1000)set sqlstr="select ID,name from Right where ID in ("
set sqlstr=sqlstr+@sRightID+")"execuse sqlstr
@sRightID varchar(500)
ASvar sqlstr varchar(1000)set sqlstr="select ID,name from Right where ID in ("
set sqlstr=sqlstr+@sRightID+")"execuse sqlstr
CREATE PROCEDURE QueryRightInfo
@sRightID varchar(500)
With ENCRYPTION
ASexec ('select ID, Name from Right where ID in (' + @sRightID + ')')if @@RowCount < 1
Return -301Return 100
Go