Sql 分割字串，sql分割字串

Sql 分割字串，sql分割字串

/*分割符為',' */declare @depid varchar(100)declare @location intdeclare @length int--樣本字串set @depid = '13434,32,34,567,12,9998,'set @location = 1set @length = 0while @location <> 0beginset @location = charindex(',', @depid, @location)if @location = 0 beginbreak;endelse begin--print @location--print @lengthprint SUBSTRING(@depid,@location - (@location - 1 - @length),@location - 1 - @length)set @location = @location + 1set @length = (@location - 1)endend 

運行結果

13434
32
34
567
12
9998

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。