Create Table and Insert data into new Table from Old Table

This code show you how to Create Table and Insert data into new Table from Old Table

SQL Code

SELECT       Id, Name
INTO            NewTable
FROM          OldTable
WHERE       (Id = '2')

Code Description

Create New Table Name called NewTable with field name Id & Name. Data insert from OldTable filter with ID = 2 .