Temp Table Exist

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

if exists (select *

from tempdb.dbo.sysobjects

where id = object_id(N'tempdb..#temptbl'))

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Edited by - antares686 on 06/18/2002 4:44:54 PM

cballew SSC Enthusiast Points: 121 More actions · Answer 2

SSC Enthusiast

Points: 121

June 19, 2002 at 4:43 am

That does it, thank you very much for the help.

Cookies on SQLServerCentral