如何通过SQL Server关键字快速定位相关存储过程、函数及视图？
- 内容介绍
- 文章标签
- 相关推荐
本文共计64个文字，预计阅读时间需要1分钟。
sqlSELECT name, type_desc FROM sys.all_sql_modules s JOIN sys.all_objects o ON s.object_id=o.object_id WHERE definition LIKE '%关键字%'ORDER BY type_desc, name;
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 '%关键字%' order by type_desc,name
本文共计64个文字，预计阅读时间需要1分钟。
sqlSELECT name, type_desc FROM sys.all_sql_modules s JOIN sys.all_objects o ON s.object_id=o.object_id WHERE definition LIKE '%关键字%'ORDER BY type_desc, name;
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 '%关键字%' order by type_desc,name