Question

sql数据库中已存在名为 '#tmp' 的对象怎么解决

insert into #tmp (id_vip)
select a.id_vip from a inner join b on a.id_vip=b.id_vip

delete from a where id_vip in (select id_vip from #tmp)
delete from b where id_vip in (select id_vip from #tmp)

在执行另的二个表时如是C表,B表时，会提示数据库中已存在名为 '#tmp' 的对象。
请问怎么解决这个问题谢谢

Answer 1

if object_id('tempdb..#tempTable') is not null
Begin
drop table #tempTable
End

Answer 2

rename

Answer 3

学习下