News

Copyright © 2008-2018 Paula DiTallo

Tag Cloud


<< 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
Thursday, January 5, 2017 10:00 PM

Feedback

No comments posted yet.

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