Skip to content

Database Consultant

Richard Brian Smith

Search for:

Categories

Azure
Docker
GCP
GDPR
HPOV
Log-Shipping
MDX
MongoDB
MS SQL 2000
MS SQL 2005
MS SQL 2008R2
MS SQL 2012
MS SQL 2014
MS SQL 2016
MS SQL 2017
MS SQL 2019
MySQL
Oracle
Oracle 11g
Oracle 9
Oracle Financials
PostgreSQL
Powershell
Reports
Spatial
SSRS
Uncategorized
UNIX
Windows

Meta

Register
Log in
Entries feed
Comments feed
WordPress.com

Temp Tables

When developing using temp tables here’s a good line to drop them if they exist.

IF OBJECT_ID('tempdb.dbo.#indexes','U') IS NOT NULL DROP TABLE dbo.[#indexes]

Share this:

Twitter
Facebook

Like this:

Like Loading...

Posted on May 17, 2011Author RichardCategories MS SQL 2000, MS SQL 2005, MS SQL 2008R2

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

Notify me of new comments via email.

Notify me of new posts via email.

Δ

Post navigation

Previous Previous post: The Oracle SCN issue

Next Next post: Orphaned Indexes

Follow Following
- Database Consultant
- Already have a WordPress.com account? Log in now.

%d bloggers like this: