SQL Server自2016版起引入了STRING_SPLIT()函数,这是一个专门用于字符串分割的内置函数。与MySQL的SUBSTRING_INDEX()不同,STRING_SPLIT()可以直接将一个字符串按指定分隔符分割成多行结果集,极大地简化了复杂字符串的处理过程。例如,SELECT value FROM STRING_SPLIT('商品ID,数量,价格', ',')将返回三行结果,每...
SELECT nodelist.value(‘(/i/@未分割)[1]’, ‘int’) as 新分割字段 FROM (SELECT CAST(‘‘ + REPLACE(‘1,2,3,4′,’,’,’‘) + ‘‘ as XML)) t(x) CROSS APPLY x.nodes(‘/i’) nodelist(n) 这里,利用xml函数将“1,2,3,4”按分号分割的sql “SELECT nodelist.value(‘(/i/@未...
create function f_split(@c varchar(2000),@split varchar(2)) returns @t table(col varchar(20)) as begin while(charindex(@split,@c)<>0) begin insert @t(col) values (substring(@c,1,charindex(@split,@c)-1)) set @c = stuff(@c,1,charindex(@split,@c),'') end insert @t(col) ...
create function f_split(@c varchar(2000),@split varchar(2)) returns @t table(col varchar(20)) as begin while(charindex(@split,@c)<>0) begin insert @t(col) values (substring(@c,1,charindex(@split,@c)-1)) set @c = stuff(@c,1,charindex(@split,@c),'') end insert @t(col) ...
1.ORACLE列变行加合计: 查询结果为 1 SELECT 2 nvl( F, '合计' ) F, 3 sum( S1 ) S1, 4 sum( S2 ) S2, 5 sum( S3 ) S3 6 FROM 7 (SELECT 8 F, 9 sum( decode( S, '