[MSSQL]키워드 SP찾기

-- 특정 테이블이 사용된 SP 조회
SELECT B.id, B.Name
FROM SYSCOMMENTS AS A
LEFT OUTER JOIN SYSOBJECTS AS B ON B.Id = A.ID
WHERE 1=1
  --AND A.text LIKE '%JdName%'
  AND A.text LIKE '%시작일이 종료%'
  --AND B.Name NOT LIKE '%Query%'
  --AND B.Name NOT LIKE '%TEST%'
  --AND B.Name LIKE '%Save%'
GROUP BY B.id,B.Name

--프로시저내용 다른것
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 '%PAY%' OR A.ROUTINE_NAME LIKE '%Search%')

--프로시저내에 구문찾기
SELECT A.ROUTINE_NAME
FROM proDocBIZ.INFORMATION_SCHEMA.ROUTINES AS A
WHERE 1=1
AND A.ROUTINE_TYPE='PROCEDURE'
AND A.ROUTINE_DEFINITION LIKE '%검색어%'