T-SQL 实现 Split
<div id="cnblogs_post_body"><div class="cnblogs_code"> 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 + ','1112 SET @cnt = len(replace(@list, ',', ',,'))-len(@list);13 SET @idxStart = 014 SET @idxEnd = 01516 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 END2425 SELECT * FROM @sites;
页:
[1]