根据关键字查找包含此关键字的存储过程名
程序员文章站
2022-11-07 19:56:46
--根据关键字查找包含此关键字的存储过程名SELECT DISTINCT t1.name FROM SYSOBJECTS t1, SYSCOMMENTS t2WHERE t1.id = t2.idAND t1.xtype = 'P'AND t2.text LIKE '%关键字%' ......
--根据关键字查找包含此关键字的存储过程名
select distinct t1.name from sysobjects t1, syscomments t2
where t1.id = t2.id
and t1.xtype = 'p'
and t2.text like '%关键字%'