Post reply

how to bulk update records in a table?

  • January 5, 2007 at 12:27 pm

    #63030

    Hello, I have a silly question which I am looking for a quick solution:

    Say I have a table with 100000 records, there are col1 and col2

    I want to update col1 with col2 for each record, how to do that? I don't want to use cursor or any complicated way, there should be a fairly simple way to do this, right?

    Thanks.

  • January 5, 2007 at 12:43 pm

    #681556

    update tablexxx

    set col1 = col2

    Tom

  • January 5, 2007 at 12:52 pm

    #681560

    Thanks Tom

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

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