当前位置:Gxlcms > mysql > 查询需要的字符串所在的存储过程及函数

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

时间:2021-07-01 10:21:17 帮助过:12人阅读

查询需要的字符串所在的存储过程及函数 无 CREATE PROCEDURE[dbo].[StringSearchInSQLObject] @TextToSearchVARCHAR(2000)ASSELECT DISTINCTOBJECT_NAME(sc.id)AS'OBJECT NAME',USER_NAME(so.uid)AS'OBJECT OWNER',CASEWHEN so.xtype='C'THEN'CHECK constrai

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

<无>
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 sc.textLIKE@TextToSearch
ORDER BY'OBJECT TYPE','OBJECT NAME'

人气教程排行