Blogs - How to tell if a temp table exists in SQL Server

Webdevshed.us

Home

Products

Devshed SQL Tools

Overview

Change Log

Download

Support Forum

FogBugz Case Importer

Overview

About the import file

Change Log

FogBugz Case Importer Download

Support Forum

Product Support Forums

Blogs

Indexes
       ASP.NET
       Generic Lists
       ComponentArt
       Data Access
       Enterprise Library
       Janus
       LINQ
       Networking
       Photoshop
       RegEx
       SQL
       SYSTEM.XML
       Telerik
       VB.Net
       SYSTEM_IO
       WPF
       WCF

Contact Us

Links

God's Plan

Text/HTML

You are here :: Blogs

Saturday, May 19, 2012

Note: This uses the internal blog search engine. The Google search engine is also available at the top of the page.

KeywordsPhrase

Archive

May 2012

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Monthly

July, 2011 (4)

June, 2011 (2)

May, 2011 (11)

April, 2011 (6)

March, 2011 (18)

February, 2011 (4)

January, 2011 (3)

December, 2010 (9)

November, 2010 (2)

October, 2010 (5)

September, 2010 (15)

August, 2010 (9)

July, 2010 (8)

June, 2010 (18)

May, 2010 (10)

April, 2010 (14)

March, 2010 (5)

February, 2010 (9)

January, 2010 (8)

December, 2009 (5)

November, 2009 (2)

October, 2009 (3)

September, 2009 (10)

August, 2009 (10)

July, 2009 (12)

June, 2009 (11)

April, 2009 (5)

Disclaimer

Please review the site disclaimer before downloading or using content found on this site

How to tell if a temp table exists in SQL Server

Apr 11

Written by: Steve Gray
4/11/2009 8:42 PM

Tested in SQL 2000 & 2005:

IF OBJECT_ID('tempdb..#tmp') IS NOT NULL
PRINT 'exists.'
ELSE
PRINT 'does not exist.'

Trackback Print

Tags:

Categories:

Location: Blogs Parent Separator

DEVSHED Blogs Child Separator

SQL

0 comment(s) so far...

As always, I welcome your comments!

Privacy Statement