Copying Data between tables

To import data from one (or) more tables into another table,T-SQL provides two statements:

• select..........into
• insert.....into....select

select....into
This statement creates destination table structure automatically without constraints and copies rows from one (or) more source tables
Tables may be temporary tables (or) permanent tables.

syntax: select */columnnames into destinationtable from sourcetable