SQL Server table replication, insert method.

1: When a new table does not exist (that is, copy the data while creating a new table with the same structure as the old table)

SELECT * to dbo.tablebackup from Dbo.tablenamewhere ID between 0 and 20

2: The new table already exists, inserting data from the old table. (Note: The primary key does not replicate)

INSERT into Dbo.tablebackup    (Col1,col2,col3,col4 ...) SELECT     Col1,col2,col3,col4 ... From Dbo.tablenamewhere ID between 0 and 20

SQL Server table replication, insert method.