3초기억력

제목 : MSSQL 함수 - asp 에서 split 같은 효과 + 인덱스번호따기 -- ============================================= -- Description: -- ============================================= CREATE FUNCTION [dbo].[keyword_Split](@strValue NVARCHAR(4000), @splitChar NVARCHAR(1)) -- 분리 문자열, 구분 문자 RETURNS @split_Temp Table(num INT, val NVARCHAR(4000)) AS BEGIN DECLARE @oPos INT, @nPos INT, @i INT DECLARE @tempVar NVARCHAR(4000) -..

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