DECLARE @NAME VARCHAR(100) SET @NAME = '' DECLARE CUR1 CURSOR FOR SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%TB_NCR2_LOT_HOLD_DETAIL_H%' -- 찾고자하는 문자열 AND ROUTINE_TYPE='PROCEDURE' ORDER BY ROUTINE_NAME OPEN CUR1 FETCH NEXT FROM CUR1 INTO @NAME WHILE (@@FETCH_STATUS = 0) BEGIN PRINT '===================== START =========================' EXEC sp_helptext @..