3초기억력

ms-sql sP --// CAT_ID 추출 SELECT @CAT_ID = CAT_ID FROM TB_CATEGORY WHERE CH_ID=@ch_id and CAT_ORDER=@cat_order and CAT_NAME=@cat_name --// 복수개의 일자ID 를 SPLIT 하여 TB_CAT_DAY 에 INSERT IF @snd_day_id'' BEGIN WHILE CHARINDEX(',', @snd_day_id) 0 BEGIN INSERT INTO TB_CAT_DAY (SND_DAY_ID, CAT_ID) VALUES (SUBSTRING(@snd_day_id,1,CHARINDEX(',',@snd_day_id)-1), @cat_id) SET @snd_day_id=SUBSTRING(@snd_day_id,..