SQL SERVER中如何查找存储过程中一段代码

select   b.name   ,a.text   from   syscomments   a,sysobjects   b 
where 
charindex('clicknum',a.text)>0    and 
object_id(b.name)=a.id   and   b.xtype   in('P','TR')

 

转载于:https://www.cnblogs.com/songr/p/9811957.html