Post reply

Quick add 1 parameter into multiple stored procedure

  • July 31, 2018 at 9:24 pm

    #407294

    hi all,
    Everyone help me please,
    I have a problem: I have a large of stored procedure (about 100). I want add 1 parameter (such as @ID varchar(50)) into all that stored procedure. How to work it ? If I alter one by one stored procedure, it is very easy but it is very long time.
    Thanks!

  • August 1, 2018 at 5:53 am

    #1999853

    guess its going to take you a long time then

    ***The first step is always the hardest *******

  • August 1, 2018 at 8:19 am

    #1999881

    Presumably you are then going to use the new parameter somewhere in the stored procedure and you are going to have to eyeball the SQL code to work out how to do that.  I'd script them all out from SSMS or from whatever source code repository you are using and just get on with it.

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

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