[MS-SQL] 전체 프로시저에서 특정 문자열이 사용된 프로시저를 찾는 법
SELECT DISTINCT a.name
FROM sysobjects AS a
LEFT JOIN syscomments AS b ON a.id = b.id
WHERE a.xtype = 'P'
AND b.text LIKE '%찾은문자열%'
SELECT DISTINCT a.name
FROM sysobjects AS a
LEFT JOIN syscomments AS b ON a.id = b.id
WHERE a.xtype = 'P'
AND b.text LIKE '%찾은문자열%'
SELECT DISTINCT a.name
FROM sysobjects AS a
LEFT JOIN syscomments AS b ON a.id = b.id
WHERE a.xtype = 'P'
AND b.text LIKE '%찾은문자열%'
