RE: Check to see if a table exists
From: Nigel Rivett (NigelRivett_at_discussions.microsoft.com)
Date: 06/24/04
- Previous message: Vishal Parkar: "Re: IIF in where clause to exclude selection criteri when null"
- In reply to: Kirk: "Check to see if a table exists"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Jun 2004 23:21:01 -0700
That will always execute the drop table
if object_id('##Table') is null
print 'True'
else
begin
print 'False'
Drop Table ##tmpTable
end
And think will only work if you are in tempdb - try
if object_id('tempdb..##Table') is null
print 'True'
else
begin
print 'False'
Drop Table ##tmpTable
end
"Kirk" wrote:
> I am running Sql Server 7.0 and I am using a store procedure to drop a global temp table if it exists.
>
> Currently, it looks like this:
>
> if object_id('##Table') is null
> print 'True'
> else
> print 'False'
> Drop Table ##tmpTable
>
> It works fine through Query Analyzer, but when I try to execute this code through ASP code, I get the following error:
>
> Microsoft OLE DB Provider for SQL Server error '80040e09' With the statement printing out TRUE that the table doesn't exist. And if doesn't exist, it should continue on and create the table as instructed.
>
> Any ideas as to what I am doing wrong? Is there a better way to check as to whether or not a table exists? Any help would be appreciated.
>
> Thanks.
>
> Kirk
>
- Previous message: Vishal Parkar: "Re: IIF in where clause to exclude selection criteri when null"
- In reply to: Kirk: "Check to see if a table exists"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
