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

8 votes122 views3 answers
Alter user root mysql
SQL
18 votes132 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote115 views1 answer
Opensuse stop MySQL
SQL
0 vote155 views2 answers
Check if sql temp table exists
SQL
0 vote129 views1 answer
Database traccar
SQL
0 vote192 views2 answers
Fanyi
SQL
1 vote117 views2 answers
Mysql show views
SQL
0 vote136 views1 answer
Drop unique
SQL
5 votes150 views2 answers
Oracle list columns
SQL
0 vote127 views1 answer
Default order by in mysql
SQL