Gentlemen / Ladies


        How can I check if a Temp Table exists, so that I can drop it?


Mark

If Object_Id('tempdb..#temptable') is Not Null
     Drop table #temptable

HTH.

Update Lock
select variable in from statement
Test for numerics?
Date/String format
PRIMARY KEY