declare @sql varchar(8000),@i intset @sql='insert into a(term,rate) select ' set @i=1 while @i<180 begin set @sql=@sql+ cast(@i as char(3)) +', 值 from b union select ' set @i=@i+1 end set @sql=@sql+ cast(@i as char(3)) +', 值 from b' exec @sql
select a.利率 from 表a a join 表b b on a.月份=b.月份
改一下 declare @sql varchar(8000),@i intset @sql='insert into a(term,rate) select ' set @i=1 while @i<180 begin set @sql=@sql+ cast(@i as char(3)) +',['+ cast(@i as char(3))+'] from b union select ' set @i=@i+1 end set @sql=@sql+ cast(@i as char(3)) +',['+ cast(@i as char(3))+'] from b' exec @sql
set @i=1
while @i<180
begin
set @sql=@sql+ cast(@i as char(3)) +', 值 from b union select '
set @i=@i+1
end
set @sql=@sql+ cast(@i as char(3)) +', 值 from b'
exec @sql
declare @sql varchar(8000),@i intset @sql='insert into a(term,rate) select '
set @i=1
while @i<180
begin
set @sql=@sql+ cast(@i as char(3)) +',['+ cast(@i as char(3))+'] from b union select '
set @i=@i+1
end
set @sql=@sql+ cast(@i as char(3)) +',['+ cast(@i as char(3))+'] from b'
exec @sql