Step 1 . If destination table have any identity column then firstly off identity by this query
.... Data Copied
Step 3 Please On its identity Column
SET IDENTITY_INSERT DestinationTable ON
Step 2 Put this query in editor
Insert into db.
DestinationTable
(clomunname1,clomunname2,clomunname3) select clomunname1,clomunname2,clomunname3 fromSourceTable
.... Data Copied
Step 3 Please On its identity Column
SET IDENTITY_INSERT DestinationTable OFF
0 comments:
Post a Comment