Monday, August 10, 2009

Checking for and dropping temp tables

IF (object_id ('tempdb.dbo.#fact_stg') is not null)

BEGIN

DROP TABLE #fact_stg

END


Again, me with the syntax ;-)

Posted by at

1 comment:

  1. Marilyn WhatmanNovember 18, 2011 at 5:31 AM

    You had left a comment on my blog about the 2012 MME calendar. I sell them at my store. If you can't locate one, I can send you it. Email me at marilyn@scrapbookersanonymous.ca

    ReplyDelete

Subscribe to: Post Comments (Atom)