SQL 에서 Split 구현하기
declare @result nvarchar(max) set @result = '' declare @param varchar(max) declare @div varchar(1) set @param = '1,2,4' set @div = ',' declare @index int declare @pos int declare @order int declare @temp varchar(max) set @index = 1 set @pos = 1 while @pos > 0 begin set @pos = charindex(@div, @param, @index) if @pos = 0 begin set @temp = right(@param, len(@param) - @index + 1) end else begin set ..
청강컴정/DataBase
2009. 4. 1. 00:01
