Post reply

Customizable Insert Script For Procedures

  • April 1, 2011 at 1:13 am

    #234153

    Hi,

    We have a database which contain 500 tables.As per the modification of the Database we want to add a column CustID to all tables.There are lot of User SP which issues insert statement.We have to add this CustID to all the Insert Statement SP's.IS there is any way to acheive this other than manually editing the SP's.Since there are Lot of SP's It is very difficult to do it manually.

    Regards

    Varun R

  • April 1, 2011 at 6:12 am

    #1306424

    adding the column to every table, or the parameter to every procedure could be scripted from the meta data,but...

    the procedures are the problem; every procedure has to be hand edited in order to decide WHAT to do with the new parameter...you don't want to add a parameter and then not do anything with it.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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