SQL server xml 单行拆分多行,多行整单行简单示例
成效结果:with cte as (select C.*,name FROM (select abc00,x.y.value('.', 'VARCHAR(16)') as abc05,KID from (select ABC00, CAST('<row>' + REPLACE(abc05, ',','</row><row>') + '</row>' as xml ) as KID FROM APP_BUSINESS_CONTRACT where
原创
2020-07-29 17:43:33 ·
1231 阅读 ·
1 评论