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 ‘%10.12.8.22%’
and name not in (
‘xxx’
)
–order by type_desc,name
一个专注于IT技术分享的网站
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 ‘%10.12.8.22%’
and name not in (
‘xxx’
)
–order by type_desc,name