查询需要的字符串所在的存储过程及函数

以下代码由PHP站长网 52php.cn收集自互联网

现在PHP站长网小编把它分享给大家，仅供参考

CREATE PROCEDURE[dbo].[StringSearchInSQLObject] 
@TextToSearchVARCHAR(2000)
AS
SELECT DISTINCT
OBJECT_NAME(sc.id)AS'OBJECT NAME',USER_NAME(so.uid)AS'OBJECT OWNER',CASE
WHEN so.xtype='C'THEN'CHECK constraint'
WHEN so.xtype='D'THEN'DEFAULT or DEFAULT constraint'
WHEN so.xtype='F'THEN'FOREIGN KEY constraint'
WHEN so.xtype='L'THEN'Log'
WHEN so.xtype='FN'THEN'Scalar function'
WHEN so.xtype='IF'THEN'Inlined table-function'
WHEN so.xtype='P'THEN'Stored procedure'
WHEN so.xtype='PK'THEN'PRIMARY KEY constraint (type is K)'
WHEN so.xtype='RF'THEN'Replication filter stored procedure'
WHEN so.xtype='S'THEN'System table'
WHEN so.xtype='TF'THEN'Table function'
WHEN so.xtype='TR'THEN'Trigger'
WHEN so.xtype='U'THEN'User table'
WHEN so.xtype='UQ'THEN'UNIQUE constraint (type is K)'
WHEN so.xtype='V'THEN'View'
WHEN so.xtype='X'THEN'Extended stored procedure'
END AS'OBJECT TYPE',CASE
WHEN sc.encrypted=0THEN'Not encrypted'
WHEN sc.encrypted=1THEN'Encrypted'
END AS'ENCRYPTED',CASE
WHEN sc.compressed=0THEN'Not compressed'
WHEN sc.compressed=1THEN'Compressed'
END AS'COMPRESSED',so.crdate AS'CREATE DATE',sc.id AS'OBJECT ID'
FROM syscomments sc INNER JOIN sysobjects soONsc.id=so.id
WHERE [email?protected]
ORDER BY'OBJECT TYPE','OBJECT NAME'

以上内容由PHP站长网【52php.cn】收集整理供大家参考研究

如果以上内容对您有帮助，欢迎收藏、点赞、推荐、分享。

（编辑：青岛站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!