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

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Lepaskan: 2016-06-07 14:56:37
asal
1486 orang telah melayarinya

查询需要的字符串所在的存储过程及函数 无 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'
Salin selepas log masuk
Kenyataan Laman Web ini
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
Tutorial Popular
Lagi>
Muat turun terkini
Lagi>
kesan web
Kod sumber laman web
Bahan laman web
Templat hujung hadapan