SQLSERVER 全局搜索SP中关键字_sqlserver全库搜索关键字

一、
SELECT  name
FROM    sysobjects o ,
        syscomments s
WHERE   o.id = s.id
        AND text LIKE '%需要查询的关键字%'
        AND o.xtype = 'P'

二、
SELECT name,
       type_desc
FROM   sys.all_sql_modules s
       INNER JOIN sys.all_objects o ON s.object_id = o.object_id
WHERE  definition LIKE N'%GLP%'
ORDER BY type_desc, name;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15