if 语句问题!!(老是提示#a已经存在)

[azhhuoiu]

declare @k int
if object_id('tempdb..#aa') is null
begin
set @k=1
end
if object_id('tempdb..#aaa') is null
begin
set @k=1
end
if object_id('tempdb..#aaaa') is null
begin
set @k=1
end
else
begin
select * into #a from (select * from #aaaa)bb
end
else
begin
select * into #a from (select * from #aaa) bb
end
else
begin
select * into #a from (select * from #aa) bb
end

[comszsoft]

用后 drop 掉。

[SoftwKLC]

--建议楼主用以下的方式写可能会比较好一点
if object_id('tempdb..#aa') is not null
drop table tempdb..#aa
go
if object_id('tempdb..#aaaa') is not null
drop table tempdb..#aaaa
go
....

[CreatHappynessMyself]

执行drop把临时表删掉。
临时表用完后要删掉的

[CreatHappynessMyself]

if object_id('tempdb..#aa') is not null
这句的效率是不是有点低？？？

[Slayer_Boxer]

看不懂..

[谁是谁的谁]

路过,学习ing...