根据关键字查找包含此关键字的存储过程名

--根据关键字查找包含此关键字的存储过程名
SELECT DISTINCT t1.name FROM SYSOBJECTS t1, SYSCOMMENTS t2
WHERE t1.id = t2.id
AND t1.xtype = 'P'
AND t2.text LIKE '%关键字%'