sql批量查找存储过程-内容

--查找存储过程-内容

 FROM sys.sql_modules AS m
INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id
WHERE o.[type] = 'P' and definition like '%NK_WEB.%'

--系统所有资料库
select name from sysdatabases where name like 'NK_WEB%'

--查找存储过程-内容

 FROM sys.sql_modules AS m
INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id
WHERE o.[type] = 'P' and definition like '%NK_WEB.%'

--系统所有资料库
select name from sysdatabases where name like 'NK_WEB%'