CREATE TABLE #MyTempTable (cola INT PRIMARY KEY)
INSERT INTO #MyTempTable VALUES (1111)
select * from #MyTempTable
drop table #MyTempTable
INSERT INTO #MyTempTable VALUES (1111)
select * from #MyTempTable
drop table #MyTempTable
drop table #临时表
else
creeate table #临时表..
INSERT INTO #MyTempTable VALUES (1111)
select * from #MyTempTable