Select into insert sql server

Sql server insert into select

INSERT INTO sales.addresses (street, city, state, zip_code) 
SELECT
    street,
    city,
    state,
    zip_code
FROM
    sales.customers
ORDER BY
    first_name,
    last_name;

Source: sqlservertutorial.net

Select into insert sql server

INSERT INTO table2
SELECT * FROM table1
WHERE condition;

Similar codes

-1 vote102 views1 answer
Condition in orderby mysql
SQL
6 votes109 views1 answer
To count number of rows in SQL table
SQL
1 vote108 views1 answer
Base64 encode sql server
SQL
5 votes103 views2 answers
Sql create tabel with primary key auto_increment code
SQL
0 vote101 views1 answer
Table values functions in SQL
SQL
1 vote102 views1 answer
MySQL AND Operator
SQL
0 vote102 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
1 vote107 views1 answer
Oracle case
SQL
1 vote124 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote107 views1 answer
Left join in codeigniter query builder
SQL