Drop all temp tables one time

Question

Viewing 7 posts - 1 through 6 (of 6 total)

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

Are you writing a stored procedure?

If so, you don't need to explicitly drop the temp tables. The whole point is that they'll go away when the connection closes at the end of the proc.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

adonetok SSCrazy Eights Points: 8395 More actions · Answer 2

SSCrazy Eights

Points: 8395

December 10, 2010 at 6:53 am

No, in query window

GSquared SSC Guru Points: 260824 More actions · Answer 3

Then you'll need to drop them explicitly.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

nzrdb6 Say Hey Kid Points: 695 More actions · Answer 4

Say Hey Kid

Points: 695

December 10, 2010 at 7:00 am

Use @table vars

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

GSquared (12/10/2010)
Then you'll need to drop them explicitly.

Well you could always reboot the server between runs :hehe:.

Pls don't try this at home folks!

GSquared SSC Guru Points: 260824 More actions · Answer 6

nzrdb6 (12/10/2010)
Use @table vars

But only if you understand the performance and transactional differences between the two.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Cookies on SQLServerCentral