Identity Specification
 

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?

Identity Specification
 

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




"tcb" wrote:

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?