总结这个SP，可用于查询需要的字符串所在的存储过程及函数等。
CREATE PROCEDURE [dbo].[StringSearchInSQLObject] @TextToSearch VARCHAR(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 = 0 THEN 'Not encrypted' WHEN sc.encrypted = 1 THEN 'Encrypted' END AS 'ENCRYPTED', CASE WHEN sc.compressed = 0 THEN 'Not compressed' WHEN sc.compressed = 1 THEN 'Compressed' END AS 'COMPRESSED', so.crdate AS 'CREATE DATE', sc.id AS 'OBJECT ID' FROM syscomments sc INNER JOIN sysobjects so ON sc.id = so.id WHERE sc.text LIKE @TextToSearch ORDER BY 'OBJECT TYPE', 'OBJECT NAME'来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23155850/viewspace-659664/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
【原创】exists 的用法
下一篇：
【笔记】C# 中的知识点小结
请登录后发表评论
登录
全部评论
