Temporary Stored Procedures

Question

Post reply

Temporary Stored Procedures

Viewing 3 posts - 61 through 62 (of 62 total)

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

INCREDIBLEmouse SSC Eights! Points: 835 More actions · Answer 1

geoff-635333 (6/25/2013)
I always forget it too - but only at the end of the session

+1

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 2

Jeff Moden (5/9/2015)
sanjarani (5/9/2015)
One of many SQL Servers features that is hardly ever used because alternative methods are more suitable.
Please explain your "alternative methods" and how they are "more suitable".

What is it with you folks that drop a bomb like this and then nothing after that?

--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.

Change is inevitable... Change for the better is not.

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

Graeme Martin Old Hand Points: 304 More actions · Answer 3

Hi, Jeff--

The one place I actually need this is when a procedure has not yet been deployed to Production, and a customer wants the output it produces. Example: sales details over two years by day in JSON format (one file per day).

One way around this is to simply restore Production to a staging server, deploy the latest release and execute the stored procedure.

But if that is not an option, a temp stored procedure could be helpful.

Graeme