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

posted @ 2022-02-24 13:06  半个程序猿Cohen_Lee  阅读(171)  评论(0编辑  收藏  举报