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')

 

posted on 2018-10-18 17:46  zooz  阅读(506)  评论(0编辑  收藏  举报