Post reply

Replace the variable value with new one (in all SP's)

  • June 24, 2011 at 1:02 pm

    #242857

    Hi,

    I have a variable and it’s used in my all stored procedure. I want to replace the variable value with new one. Is there a way we can replace the variable with some other one in all the SP and recompile it using the Query.

    Thanks,

    JK

  • June 24, 2011 at 1:08 pm

    #1343888

    jvskarthick (6/24/2011)

    Hi,

    I have a variable and it’s used in my all stored procedure. I want to replace the variable value with new one. Is there a way we can replace the variable with some other one in all the SP and recompile it using the Query.

    Thanks,

    JK

    Not easily. Script them all out to a single script and use find/replace is probably your best bet.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

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

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