Data Copy into new Table from Old Table

This code show you how to Data Copy  into new Table from Old Table

SQL Code

INSERT INTO   [Table1]
                           (Id, Name)
SELECT             OldTable AS ID, Name
WHERE             (ID = '2')

Code Description
Id & Name field Data Copy from OldTable into Table1 filter with ID = 2 .