SQL Server Performance

update records

Discussion in 'General DBA Questions' started by Raulie, Mar 24, 2004.

  1. Raulie New Member

    I want to update a table column with values 500- 1000 for istance lets say the table already contains 500 records there is a column that is null I want to update it with these values.

  2. Twan New Member

    Options are:
    - use a cursor agains the table to update each record in turn
    - add an identity column to the table, and then use this to update your null column, then drop the identity column


Share This Page