帮忙看看为什么sql2000老提示我已存在临时表对象呢？

[liquidcn]

存储过程：

if .....
select * into #t from tab where....
else if ....
select * into #t from tab where...
else if ...
select * into #t from tab where...

select .... from #t where ...

drop table #t


我想根据一些条件创建不同的临时表（名字都一样），最后再对临时表进行查询，但数据库老是报：there is already an object named "#t" in the database

我已经无解了，望高人指教

[水族杰纶]

IF OBJECT_ID('TEMPDB..#t')IS NOT NULL DROP TABLE #T

[肥龙上天]

更改为
select * into #1 from tab where 1 =2

if ...
	insert #1 select * from tab where
else if ...
	insert #1 select * from tab where


drop table #1

[htl258_Tony]

已经有一个对象命名为“ ＃ T ”型的数据库中

if object_id('tempdb..#t') is not null drop #t
if ..... 
  select * into #t from tab where.... 
else if .... 
  select * into #t from tab where... 
else if ... 
  select * into #t from tab where... 

select .... from #t where ... 

drop table #t 

[playwarcraft]

create table #t(...)
if ..
insert into #t select ..

[dawugui]

if object_id('tempdb..#t') is not null drop table #t

[liquidcn]

就是这样的：

if object_id('tempdb..#t') is not null
drop table #t

if .....
select * into #t from tab where....
else if ....
select * into #t from tab where...
else if ...
select * into #t from tab where...

select .... from #t where ...

drop table #t

仍然报错啊……

[playwarcraft]

这样编译过不了的，还是用create #t...再insert吧。。

[liquidcn]

拜托楼上讲详细点，急啊

[水族杰纶]

if   object_id( 'tempdb..#t ')   is   not   null 
    drop   table   #t 
GO
CREATE TABLE #T (ID INT ,.....)
if   ..... 
    INSERT #t SELECT *   from   tab   where.... 
else   if   .... 
    INSERT #t SELECT *    from   tab   where... 
else   if   ... 
    INSERT #t SELECT *    from   tab   where... 

select   ....   from   #t   where   ... 

drop   table   #t 

[liquidcn]

ok,thanks

[-狙击手-]

declare @s varchar(8000)
if .....
set @s = '...'
else if ....
set @s = '...'
else if ...
set @s = '...'
exec('select * into tmp from .. where '+@s)

select .... from tmp where ...

drop table tmp