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 '%hw%' order by type_desc,name
用途:在数据库迁移过程中如果之前是使用的外链访问,在后来将两个库进行了合并,就避免不了要修改全部的带外链的sql,查询sql如下: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 '%hw%...