Post reply

Update several tables with same column names

  • June 11, 2003 at 5:10 am

    #81062

    Hi,

    I'm sure this is quite easy but i just cant think!

    I need to update a column to the same value on 6 different tables. The column names are the same.

    Is there a simple way without having to do each table seperately?

    Thanks

    MH

  • June 11, 2003 at 5:15 am

    #460729

    AFAIK, there is no simple way. You have to update the tables separately.

    If this is something you need to do often, you might want to construct a stored procedure for doing this.

  • June 11, 2003 at 6:07 am

    #460734

    Agree, no simple way.

    If the table names have something unique and common, eg all start with fred (fred1,fred2 etc) the you could use sp_MSforeachtable to repeat the update on each table.

    Far away is close at hand in the images of elsewhere.
    Anon.

  • June 11, 2003 at 6:21 am

    #460737

    Thanks Guys! Manually it is then....

    Meg

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

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