效果
代码
SELECT * FROM excel_house_zz_nydqc_temp_data
--将逗号分隔的数据变成多行数据
;with Roy as
(select batch_guid,tsbh,fwz_zjlx=cast(left(fwz_zjlx,charindex(',',fwz_zjlx+',')-1) as nvarchar(100)),Split_1=cast(stuff(
效果
代码
SELECT * FROM excel_house_zz_nydqc_temp_data
--将逗号分隔的数据变成多行数据
;with Roy as
(select batch_guid,tsbh,fwz_zjlx=cast(left(fwz_zjlx,charindex(',',fwz_zjlx+',')-1) as nvarchar(100)),Split_1=cast(stuff(