SQL ÁÙʱ±íÑ­»·²åÈëÊý¾Ý

.
.
.
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' µÄ¶ÔÏó¡£

---

ÁÙʱ±íform1' ûɾ³ý°É

---

SQL code:

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  ÒѾ­´æÔÚ

±ØÐëÏÈɾ³ýһϡ£


SQL code:
drop table #form1

---