Sql-server inserting multiple rows of data with insert-syntax and examples

Inserting multiple rows of data, having more than one piece of data in the original table, and building a new table can be cumbersome, using the following syntax:

Add data from an existing table to a table that already exists by using the Insert Select statement
Syntax: Insert into< new table name > (column name)
select< Column Name >
from< Old table name >
Note: The AddressList table must be pre-created and has a column name

Add data from an existing table to a new table by using the select into statement
Syntax:select< column name >--column name of old table
into< New Table name >
from< Old table name >

Sql-server inserting multiple rows of data with insert-syntax and examples