[MSSQL]검색어로 프로시저 찾기

SELECT A.ROUTINE_NAME
FROM proDocBIZ.INFORMATION_SCHEMA.ROUTINES AS A
JOIN coaonBIZ.INFORMATION_SCHEMA.ROUTINES AS B ON A.ROUTINE_TYPE='PROCEDURE'
                                               AND A.ROUTINE_NAME = B.ROUTINE_NAME
                                               AND A.ROUTINE_DEFINITION != B.ROUTINE_DEFINITION
WHERE 1=1
  AND (A.ROUTINE_NAME LIKE '%찾을단어1%' OR A.ROUTINE_NAME LIKE '%찾을단어2%')

프로시저내에 구문찾기

SELECT A.ROUTINE_NAME
FROM proDocBIZ.INFORMATION_SCHEMA.ROUTINES AS A
WHERE 1=1
AND A.ROUTINE_TYPE='PROCEDURE'
AND A.ROUTINE_DEFINITION LIKE '%검색어%'