3초기억력

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[SP_ConfigDel] @returnv int output, @DATA VARCHAR(1000) AS BEGIN BEGIN TRAN WHILE CHARINDEX(',',@DATA)0 BEGIN Update TB_ConfigData set SFlg='N' , SFlgDate=getdate() where IDX=SUBSTRING(@DATA,1,CHARINDEX(',',@DATA)-1) SET @DATA=SUBSTRING(@DATA,CHARINDEX(',',@DATA)+1,LEN(@DATA)) IF CHARINDEX(',',@DATA)=0 BREAK ELSE CONTINUE END EN..