<< How to find out the name of the stored procedure that is currently executing | Enabling/Disabling a Windows Forms Close Button >>

How to determine if a SQL temp table exists

by Andrew Jackson 12. September 2009 04:55

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

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags:

Development | SQL

Related posts

Finding Duplicate Record Entries in SQLThis article describes how to identify duplicate records in a SQL table. Use the Group By / Havin...New Download - NUnit templates for Visual Studio 2005I've been investigating NUnit recently and was getting frustrated by the amount of repetitive code y...SQL Command Visualizer for Visual Studio 2005I've finally got round to writing a visualizer I've been wanting for years, one that will give a dec...

Comments are closed

Powered by BlogEngine.NET 1.4.5.0
Theme by Mads Kristensen

RecentComments

Custom Settings Providers and Portable applications/U3 Drives (1)
Pärmar wrote: Doing a little research. Your post helped me – tha… [More]
Getting into Android development (1)
Baltimore Cooling wrote: When is the next post comming on this topic. … [More]
New Printer (5)
infrared illuminators wrote: Hi nice site design Regards Cook [More]
Saving Settings (6)
white board wrote: I added your post to my college Report Regard… [More]
Large Text Properties and Reflector (1)
seattle divorce lawyer wrote: I posted your blog to my facebook group Regar… [More]
New Download - WaitCursor Snippets for Visual Studio 2005 (4)
Gucci Bags wrote: I added your post to my college Report Regard… [More]
Allowing HTML to be entered into text boxes on ASP.net (2)
Photo to Pop Art wrote: Wonder full writing skills you got mate. Rega… [More]
VB.net 2005 - Easy settings persistance (5)
dog stroller wrote: Wonder full writing skills you got mate. Rega… [More]
New Download - GUID Visualizer for Visual Studio 2005 (4)
snoozer bed wrote: Hi nice POst Regards Moore [More]
Lisbox, IntegralHeight property (2)
patio aluminum furniture wrote: Now this is hghly recommeded post for me. I will s… [More]