Simon's Bits and Bobs

Wednesday, 20 July 2016

SQL Server - Checking whether a temp table exists

IF OBJECT_ID('tempdb..#tmpTable1') IS NOT NULL
  drop table tempdb..#tmpTable1
Posted by Simon Turner at 08:07
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Simon Turner
View my complete profile

Blog Archive

  • ▼  2016 (23)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
    • ▼  July (6)
      • SQL Server - Checking whether a temp table exists
      • SQL Server - drop an index if exists
      • SQL Server - How to create a view with an index
      • SQL Server - How to create a view with an index
      • SQL Server - How to create a view with an index
      • How to monitor backup and restore progress in SQL ...
    • ►  June (2)
    • ►  March (1)
    • ►  February (1)
    • ►  January (10)
Simple theme. Powered by Blogger.