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...