Rumah >pangkalan data >tutorial mysql >查询需要的字符串所在的存储过程及函数

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

WBOY
WBOYasal
2016-06-07 14:56:371459semak imbas

查询需要的字符串所在的存储过程及函数 无 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'
Kenyataan:
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn