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%'