The Temp Alias

Question

Post reply

The Temp Alias

Steve Jones - SSC Editor

SSC Guru

Points: 730291
More actions
December 9, 2022 at 12:00 am

#4116665

Comments posted to this topic are about the item The Temp Alias
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 9, 2022 at 7:44 am

This was removed by the editor as SPAM

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

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

Jeff Moden SSC Guru Points: 1002113 More actions · Answer 1

And you should see what happens when you drop the table! 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Dear Lord... I'm a production DBA. Please grant me patience because, if you grant me strength, I'm gonna need bail money to go with it.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

corey.furman 23112 Newbie Points: 3 More actions · Answer 2

I wasn't familiar with aliasing a temp table. How is this useful? I'm struggling to think of a use case.

Steve Jones - SSC Editor SSC Guru Points: 730291 More actions · Answer 3

I struggle with a use case as well. I was honestly surprised this was available as a possibility.

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

Jason A. Long SSC-Insane Points: 23755 More actions · Answer 4

You could create a separate stored procedure that accepts a spid as an input parameter.

The stored proc would be a simple WAITFOR command that waits for a period of time and then kills the spid if that spids connection time is longer than the waitfor time.

Then all you’d have to do is call that proc in your main procedure, using @@SPID.

Jeff Moden SSC Guru Points: 1002113 More actions · Answer 5

Jason A. Long wrote:

You could create a separate stored procedure that accepts a spid as an input parameter. The stored proc would be a simple WAITFOR command that waits for a period of time and then kills the spid if that spids connection time is longer than the waitfor time. Then all you’d have to do is call that proc in your main procedure, using @@SPID.

Calling a different stored procedure from a main stored procedure isn't an asynchronous event. How would you make it so it was?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Dear Lord... I'm a production DBA. Please grant me patience because, if you grant me strength, I'm gonna need bail money to go with it.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jason A. Long SSC-Insane Points: 23755 More actions · Answer 6

You are 100% correct Jeff. Complete brain fart on my part. Please disregard my previous comment.