例子1
| 代码如下 | 复制代码 |
|
select OBJECT_NAME(id),id from syscomments where id in ( select object_id(name) from dbo.sysobjects where xtype='P' ) and text like '%FieldName%' group by id |
|
例子2
在数据库SQL Server 2005/2008中，查询包含某关键字的存储过程语句：
| 代码如下 | 复制代码 |
|
select distinct b.name from dbo.syscomments a, dbo.sysobjects b where a.id=b.id and b.xtype='p' and a.text like '%text%' order by name |
|
例子3
关键字查找相关的存储过程、触发器、函数和视图
| 代码如下 | 复制代码 |
|
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 '%keyword%' order by type_desc,name |
|
时间： 2024-10-30 09:18:19