.
.
.
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' 的对象。
.
.
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' 的对象。
select a.fname as a1,b.sum1 as a2,c.sum2 as a3,d.sum3 as a4 into #form1 from
.
改成
insert #form1 ()values select ....
drop table #form1
if object_id('tempdb.dbo.#form1') is not null drop table #ta
go
if object_id('tempdb.dbo.#form1') is not null drop table #form1
go
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