22,210
社区成员
发帖
与我相关
我的任务
分享
是的化使用下面的方法删除临时表..##TEMP_COPTD
IF OBJECT_ID( 'tempdb..##TEMP_COPTD') IS NOT NULL
Begin
DROP TABLE ##TEMP_COPTD
End
select * into abc from tableA
if object_id('abc','U') Is Not Null
drop Table abc
/****** 对象: Table [dbo].[A] 脚本日期: 07/20/2011 11:06:42 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[A]') AND type in (N'U'))
DROP TABLE [dbo].[A]
if object_id('test','U') Is Not Null
Drop Table test
select * into a from b
if exists (select 1 from sysobjects where id = object_id('a') and type = 'U')
drop table a