<< How can I get a list of what windows patches were installed? | Home | SQL Server: How can I tell if a table is being used? >>
SQL Server: How do I test for the existence of a temp (#temp) table before dropping it?
This statement will work 

if object_id('tempdb..#mytempTbl') is not null
  drop table #mytempTbl
posted on Thursday, January 5, 2017 10:00 PM
Filed Under [ Practical Answers SQL ]

Comments

No comments posted yet.

Post A Comment
Title:
Name:
Email:
Comment:
Verification: