저장 프로시저(Stored Procedure) 내용 검색하기

DECLARE @WORD VARCHAR(100) = '검색 단어'
SELECT NAME
	, RESULT = SUBSTRING(MAX(TEXT),PATINDEX('%'+@WORD+'%',MAX(TEXT)),LEN(@WORD))
FROM SYSOBJECTS AS O
INNER JOIN SYSCOMMENTS AS C
ON O.id = C.ID
WHERE O.XTYPE='P'
	AND C.TEXT LIKE '%' + @WORD + '%'
GROUP BY NAME
ORDER BY NAME