Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: how to update a list of data in one shot

    how to update a list of data like the following:

    update X12345 to ABC12345
    update X56789 to ABC56789
    update X13579 to ABC13579

  2. #2
    Join Date
    Sep 2003
    The extremely Royal borough of Kensington, London
    update table
    set column = newRow
    where column = condition

    How do you wish to obtain your new values, most probably via a sub-query?

    On what condition will a given row be updated?
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts