I am trying to import Data from an old table to an new table. But I create an new PK in the new table(int), the old table's PK just become one the columns in the new table. When I import data from the old to the new table. I have one extra PK column in the new table, which has nothing to import from the old table. SQL did not let me import data since the new PK can not be NULL. I am wondering if I can let SQL create PK value when I am importing the Data from the old table to the new table? Or there are some other ways to do it? Any suggestion or idea? Thanks alot