同一种方法,不同符号只需要将代码中的符号替换即可,注意大小写!!!
测试数据
SQL语句
--逗号分隔
declare @select nvarchar(max)
set
@select = 'select approveid ='''+REPLACE((select typedata from test where listname ='逗号分隔数据转表'),',','''
union all select ''')+''''
create table #base(
dataresult nvarchar(50)
)
insert into #base exec (@select)
select dataresult from #base
drop table #base
结果: