Insert PK to another database

Hi all,

  I have another challenge. I insert a certain rows from one database to another by using insert SQL

SQL>insert into target_table select * from source_table_at_link_name  where PK = '15';

1 rows inserted

 However, it insert into the target_table of my new database with new PK number and I have to go inside and manually edit the PK. Is there a way that I can keep the same PK number by using insert without going inside the table update manually?

Thanks

David Received on Tue Feb 25 2003 - 21:17:49 CST