How can I check for existence of #TempTable? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How can I check for existence of #TempTable?

Message

From

08/05/2006 04:57:43

Jon Neale
Bond International Software
Wootton Bassett, United Kingdom

To

08/05/2006 04:40:48

Peter Pirker
Frederiksberg, Denmark

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: How can I check for existence of #TempTable?

Miscellaneous

Thread ID:

01119975

Message ID:

01119976

Views:

18

This message has been marked as the solution to the initial question of the thread.

IF Object_Id('tempdb..#tempas') IS Not Null

>Well, that's pretty much it!
>
>Thank's in advance.
>
>BR

Click here to load this message in the networking platform