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

查询需要的字符串所在的存储过程及函数 无 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'

本文原创发布php中文网，转载请注明出处，感谢您的尊重！