Identity Specification

  • Thread starter Thread starter tcb
  • Start date Start date
T

tcb

I have a PK column defined with.

Identity Specification = Yes
Is Identity = Yes
Identity Increment = 1
Seed = 1

The table has no data. Is it possible to import from another table
with unique numbers into this column?
 
it sounds like you're in the wromg news group. But yes.

First switch off the column's identity, leaving it just as a BIGINT

the you
INSERT INTO thistable (tableid) values select distinct (col) from tablesource

then turn on the identity again
 
Back
Top