Identity Specification

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?
 
P

Patrick Molloy

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
 

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

sqlite-odbc write conflict 2
Setting column width in a table with a macro is not working 0
Autonumber field in Excel that behaves the same as Access 0
Insert data into SQL Server db - find out the record number 6
List all tables, including document structure 0
Excel does not accept text format! 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Identity Column in SQL Server View 3

Top