查看SQLServer中存储过程包含的关键字

 SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_DEFINITION LIKE '%山山水水%' 
AND ROUTINE_TYPE='PROCEDURE'