Temporary Stored Procedures

  • geoff-635333 (6/25/2013)


    I always forget it too - but only at the end of the session

    +1

  • 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)
    Intro to Tally Tables and Functions

  • 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

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

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