where o.id=s.id and text LIKE ‘%text%‘ and o.xtype=‘p‘
SQL Server中查找包含某个文本的存储过程
标签：
SQL Server中查找包含某个文本的存储过程
name,text from sysobjects o,syscomments s
where o.id=s.id and text LIKE ‘%text%‘ and o.xtype=‘p‘
where o.id=s.id and text LIKE ‘%text%‘ and o.xtype=‘p‘