可以这样:
declare @insertSql varchar(100)
declare @insertSql1 varchar(4000)
declare @insertSql2 varchar(4000)
set @insertSql='
create table #temp2 '
set @insertSql1='
insert into #temp2 values('''+REPLACE(@var,',',''') '
set @insertSql2='
insert into #temp2 values(''')+''')'
exec (@insertSql+@insertSql1+@insertSql2) 或者:exec ('
create table #temp2
insert into #temp2 values('''+REPLACE(@var,',',''')insert into #temp2 values(''')+''')'
)
declare @insertSql varchar(100)
declare @insertSql1 varchar(4000)
declare @insertSql2 varchar(4000)
set @insertSql='
create table #temp2 '
set @insertSql1='
insert into #temp2 values('''+REPLACE(@var,',',''') '
set @insertSql2='
insert into #temp2 values(''')+''')'
exec (@insertSql+@insertSql1+@insertSql2) 或者:exec ('
create table #temp2
insert into #temp2 values('''+REPLACE(@var,',',''')insert into #temp2 values(''')+''')'
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货