Quick add 1 parameter into multiple stored procedure

  • thaitinh77

    SSC Veteran

    Points: 279

    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!

  • SGT_squeequal

    SSCertifiable

    Points: 7163

    guess its going to take you a long time then

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

  • tripleAxe

    SSCertifiable

    Points: 5605

    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 3 (of 3 total)

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