查找存储过程内的内容

设 @procName 为存储过程的名称

declare @objID int
select @objID = ID from sysobjects where name = 'test'

select text from syscomments where ID = @objID