There is a database rk in it table dbo.RDRBP . There is also a rk_new database and it has exactly the same table. How to update a table in rk_new from a table in rk . I wrote this:

USE rk_new INSERT INTO dbo.RDRBP SELECT * FROM rk.dbo.RDRBP

But the error takes off: Message 8101, level 16, state 1, line 2 The value of the column of identifiers in the table "dbo.RDRBP" can be indicated explicitly only when using the list of columns and when IDENTITY_INSERT is set to ON. Tell me what to do.

  • Do you want to update the rk_new table or is it empty and you want to transfer all the data from the rk table? - null

1 answer 1

 INSERT rk_new.dbo.RDRBP () SELECT .. FROM rk.dbo.RDRBP

In the list of columns, write all the important columns, except ID. If you need to transfer from ID, then at the time of transfer it will disable the identity of the table column in the database rk_new