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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Increment Field or Identity Field In MS SQL Server 0
Suggestion for Macro to Delete Dups based on all fields 4
VBA comparing sheets and cells 1
Insert data into SQL Server db - find out the record number 6
6 digits Unique Number 6
Advanced transpose/grouping question 7
Sub to stack data n paste unique order ID lines 3
Code copies twice...? 13

Back
Top