SQL 临时表循环插入数据

[lijujie19860802]

.
.
.
Create TABLE #form1(
UID int identity(1, 1) PRIMARY KEY,
fname varchar(50),
sum1 varchar(50),
sum2 varchar(50),
sum3 varchar(50))
.
.
.
while (@i<=@row)
begin
select a.fname as a1,b.sum1 as a2,c.sum2 as a3,d.sum3 as a4 into #form1 from
.
.
.
set @i=@i+1
end
select a1 as '加工户名' ,a2 as '经轴期初余额',a3 as '纬丝期初余额',a4 as '布期初余额' from #form1
drop table #form1


错误是 服务器: 消息 2714，级别 16，状态 1，过程 selectall，行 23
数据库中已存在名为 '#form1' 的对象。

[SQL77]

临时表form1' 没删除吧

[华夏小卒]

select a.fname  as a1,b.sum1 as a2,c.sum2 as a3,d.sum3 as a4  into #form1 from 
. 
改成
insert #form1  ()values select ....

[贾桂权]

#form1 已经存在

必须先删除一下。

drop table #form1

[贾桂权]

[Quote=引用 2 楼 js_szy 的回复:]
SQL codeselect a.fnameas a1,b.sum1as a2,c.sum2as a3,d.sum3as a4into #form1from
.
改成insert #form1 ()valuesselect ....
[/Quote]


对。

[SQL77]

INSERT into #form1 select a.fname  as a1,b.sum1 as a2,c.sum2 as a3,d.sum3 as a4  from 

[--小F--]

---先这样
if object_id('tempdb.dbo.#form1') is not null drop table #ta
go 

[sgtzzc]

先建表，再插数据

select into 每循环一次会创建一次表

[feixianxxx]

楼上各位早~

[--小F--]

---先这样
if object_id('tempdb.dbo.#form1') is not null drop table #form1 
go

[bancxc]

if object_id('tempdb..#form1') is not null
    insert into #form1 select 。。。。。。。。。。。。。。
else
    select a.fname  as a1,b.sum1 as a2,c.sum2 as a3,d.sum3 as a4  into #form1 from 

[lijujie19860802]

[Quote=引用 3 楼 jia_guijun 的回复:]
#form1  已经存在

必须先删除一下。


SQL codedroptable #form1
[/Quote]

我要把多条数据都放到这个临时表里面，怎么可以删呢

[lijujie19860802]

[Quote=引用 10 楼 bancxc 的回复:]
SQL codeifobject_id('tempdb..#form1')isnotnullinsertinto #form1select 。。。。。。。。。。。。。。elseselect a.fnameas a1,b.sum1as a2,c.sum2as a3,d.sum3as a4into #form1from
[/Quote]

好像很好的样子，谢谢