SQL查找所有存储过程是否存在某个关键字(词)

--将ApPayCostDetail替换成你要查找的内容

SELECT
	name 
FROM
	sysobjects o,
	syscomments s 
WHERE
	o.id = s.id 
	AND text LIKE '%ApPayCostDetail%' 
	AND o.xtype = 'P' 
SELECT
	ROUTINE_NAME,
	ROUTINE_DEFINITION 
FROM
	INFORMATION_SCHEMA.ROUTINES 
WHERE
	ROUTINE_DEFINITION LIKE '%ApPayCostDetail%' 
	AND ROUTINE_TYPE = 'PROCEDURE'