var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: T-SQL increment
i have got 22,000 rows in a table, i want to update the records to have to start id of 70000 which increments to 70001, 70002 ? how would i go about doing this ?
DBCC CHECKIDENT ('table_name', RESEED, 70000)
That will set the next identity value to 70000. That should get you started. You have a couple of options from there. Come back if you need more help.
Last edited by cascred; 10-11-05 at
i actually DTS the data out into temp table and went into enabled the identity on the column to start at 70000. Does this DBCC reseed only existing columns where the identity option has been specified ?
You can only have one identity column per table. The DBCC command will reseed the counter, but it does not change existing values.