T-SQL 實現 Split

 1 DECLARE @list VARCHAR(100), @cnt INT, @idxStart INT, @idxEnd INT 2 DECLARE @sites TABLE(id INT) 3   4 SET @list = '23, 34, 44, 56, 78'; 5 --SET @list = '23'; 6   7 SET @list = replace(@list, ' ', '') 8   9 IF(RIGHT(@list, 1)<>',')10       SET @list = @list + ','11  12 SET @cnt = len(replace(@list, ',', ',,'))-len(@list);13 SET @idxStart = 014 SET @idxEnd = 015  16 WHILE @cnt > 017 BEGIN18       SET @idxEnd = charindex(',', @list, @idxStart)19       INSERT INTO @sites VALUES(convert(INT, substring(@list, @idxStart, @idxEnd-@idxStart)));20      21       SET @idxStart = @idxEnd + 122       SET @cnt = @cnt - 123 END24  25 SELECT * FROM @sites;

其實很簡單, 應該也比較好理解. 網上包括園子裡還有N多其它的實現, 可以看看這個(T-SQL的Split)感覺也不錯的. 關鍵是想法.