/******************************************************
* SQLServer字符串批量拆分函数
--原始数据
id names
----------- --------------------
1 ljy,zwg,cym
2 czg,zy
--生成的数据
id rn name
----------- ----------- ----------
1 1 ljy
1 2 zwg
1 3 cym
2 1 czg
2 2 zy
--示例1:
declare @table table(id int , names varchar(20))
insert into @table select 1, 'ljy,zwg,cym'
insert into @table select 2 , 'czg,zy'
SELECT * FROM @table
SELECT a.id,rn,b.v AS name
FROM @table AS a outer apply dbo.uf_split_string_batch(a.names)b
--示例2:
SELECT a.c_guid,rn,b.v AS name
FROM tb_contract a
outer ap
* SQLServer字符串批量拆分函数
--原始数据
id names
----------- --------------------
1 ljy,zwg,cym
2 czg,zy
--生成的数据
id rn name
----------- ----------- ----------
1 1 ljy
1 2 zwg
1 3 cym
2 1 czg
2 2 zy
--示例1:
declare @table table(id int , names varchar(20))
insert into @table select 1, 'ljy,zwg,cym'
insert into @table select 2 , 'czg,zy'
SELECT * FROM @table
SELECT a.id,rn,b.v AS name
FROM @table AS a outer apply dbo.uf_split_string_batch(a.names)b
--示例2:
SELECT a.c_guid,rn,b.v AS name
FROM tb_contract a
outer ap