会python真的可以为所欲为0(回)
332天前
这里还有人吗1(回)
517天前这里还有人吗0(回)
517天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
741天前到处都是羊，不想上班0(回)
821天前
鸽子
0(回)
826天前DECLARE @keyWord AS NVARCHAR(128) = N'keyWord' |
|
SELECT DISTINCT 'Stored Procedure' [Type], |
'[' + SCHEMA_NAME(sp.schema_id) + '].[' + sp.NAME + ']' [Name], |
sp.NAME |
FROM sys.all_objects AS sp |
INNER JOIN dbo.syscomments c |
ON c.id = sp.object_id |
AND CASE |
WHEN c.number > 1 |
THEN c.number |
ELSE 0 |
END = 0 |
WHERE (c.TEXT LIKE N'%' + @keyWord + N'%') |
AND ( |
( |
sp.type = N'P' |
OR sp.type = N'RF' |
OR sp.type = N'PC' |
) |
AND ( |
CAST(CASE |
WHEN sp.is_ms_shipped = 1 |
THEN 1 |
WHEN ( |
SELECT major_id |
FROM sys.extended_properties |
WHERE major_id = sp.object_id |
AND minor_id = 0 |
AND class = 1 |
AND NAME = N'microsoft_database_tools_support' |
) IS NOT NULL |
THEN 1 |
ELSE 0 |
END AS BIT) = 0 |
) |
) |
AND sp.NAME <> @keyWord |
|
UNION ALL |
|
SELECT 'View' [Type], |
QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) [Name], |
TABLE_NAME |
FROM INFORMATION_SCHEMA.VIEWS |
WHERE VIEW_DEFINITION LIKE N'%' + @keyWord + N'%' |
AND TABLE_NAME <> @keyWord |
中级程序员
by: GOICE 发表于：2019-07-10 11:27:48 顶(0) | 踩(0) 回复
收藏，备用.
回复评论