SQL Server copies data from a table to another table

Insert into Phone2 (ph,attr,type,carrier) Select Top + ph,attr,type,carrier from phone

Copy the field of the table phone and the first 1000 data to the Phone2 table

A table in the database deletes duplicate data (the Phone2 table cannot exist)

SELECT DISTINCT * to Phone2 from phone

Table phone data is put into phone2 (phone2 table can exist)
Insert into Phone2 (ph,attr,type,carrier) SELECT DISTINCT (ph), attr,type,carrier Fromphone

Delete Phone table
TRUNCATE TABLE Phone

Table Phone2 data back into the phone table to ensure that the name of the table is the same
INSERT into Phone (ph,attr,type,carrier) Selectph,attr,type,carrier from Phone2