T-SQL问题解决集锦――数据加解密(三)
DECLARE @proc VARCHAR(100)= 'test'
--存储过程名
DECLARE @exName NVARCHAR(100)= '代码内容'
--扩充属性名 www.2cto.com
--将原本结果查询
SELECT value
FROM sys.all_objects AS sp
INNER JOIN sys.extended_properties AS P ON P.major_id = sp.object_id
AND P.minor_id = 0
AND P.class = 1
WHERE ( P.name = @exName )
AND ( ( sp.type = N'p'
OR sp.type = N'rf'
OR sp.type = 'pc'
)
AND ( sp.name = @proc
AND SCHEMA_NAME(sp.schema_id) = N'dbo'
)
)
作者 黄钊吉