Post reply

Add a new column to Table through SP

  • April 29, 2015 at 10:27 am

    #307526

    I am loading a table thru a store Proc but now we need to add another Column to that SP to be loaded in that table.How can I do that?

    SP is USP_Prod_Data and TableName dbo.Prod_Data

  • April 29, 2015 at 10:33 am

    #1794400

    What is your specific question? You can edit the proc and add another parameter (with a default value) if you want it to be backward compatible.

  • April 29, 2015 at 11:25 am

    #1794417

    No worries, I had to make changes both ways , Proc n table which I was missing.

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

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