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 vote205 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote236 views1 answer
Plpgsql create function
SQL
9 votes192 views5 answers
Sql limit
SQL
6 votes190 views1 answer
SQL insert all columns
SQL
18 votes211 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
5 votes168 views1 answer
Ora-00054 find lock
SQL
50 votes292 views6 answers
Sql count duplicate rows
SQL
0 vote182 views1 answer
Sql server change schema of a table
SQL
2 votes179 views1 answer
Mysql clear screen
SQL
37 votes394 views3 answers
Sql check duplicate value in column
SQL