Table replication between SQL Server databases

Take database T1 and test as an example.

1. Copy the table structure and data select * into database name. DBO. Table name from source table (all data)
For example, select * into t1.dbo. YS1 from test. DBO. dxys: copy the dxys table and data in the test database to the T1 database and name it YS1. The YS1 table in T1 is newly created.
2. Full Replication Insert into database 1. DBO. Table 1 select * from database 2. Table 2, for example, insert into test. DBO. YS Select * from test. DBO. dxys. The data structure of the two tables is the same. The result of this statement is to copy the data in the dxys table to the YS table.
3. Do not copy duplicate records Insert into database 1. Table 1 select distinct * from database 2. Table 2 (No Repeated Records in tabulation 2)