MS-SQL 프로시져 내용검색

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