本文转自
aammjian的博客:http://jayai.blog.51cto.com/510093/245770
查询存储过程中含某字段的所有存储过程:
select
distinct
name,
text
from report.dbo. syscomments a,report.dbo. sysobjects b
where a.id=b.id and b.xtype= 'p' and a. text like '%终审时间%'
from report.dbo. syscomments a,report.dbo. sysobjects b
where a.id=b.id and b.xtype= 'p' and a. text like '%终审时间%'
查询某库中的所有存储过程:
SELECT *
FROM
SysObjects
WHERE [xtype] =
'P'
查询某存储过程的内容:
EXEC
Sp_HelpText
'存储过程名'
转载于:https://blog.51cto.com/shane/398319