1、错误的删除操作:
2、正确的删除方式:
--
错误的临时表删除操作,因为所在数据库不同
IF EXISTS ( SELECT * FROM sysobjects WHERE object_id = OBJECT_ID(N ' [dbo].[#tempTable] ') AND type in (N ' U '))
Begin
DROP TABLE [ dbo ]. [ tempTable ]
End
-- 错误的临时表删除操作,因为临时表名已变
if exists ( select * from tempdb.dbo.sysobjects where id = object_id(N ' [#temptable] '))
Begin
drop table #temptable
End
IF EXISTS ( SELECT * FROM sysobjects WHERE object_id = OBJECT_ID(N ' [dbo].[#tempTable] ') AND type in (N ' U '))
Begin
DROP TABLE [ dbo ]. [ tempTable ]
End
-- 错误的临时表删除操作,因为临时表名已变
if exists ( select * from tempdb.dbo.sysobjects where id = object_id(N ' [#temptable] '))
Begin
drop table #temptable
End
2、正确的删除方式:
--
正确的临时表删除操作
if object_id( ' tempdb..#tempTable ') is not null Begin
drop table #tempTable
End
if object_id( ' tempdb..#tempTable ') is not null Begin
drop table #tempTable
End