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

6 votes110 views2 answers
Drop foreign key
SQL
0 vote112 views1 answer
Update top 100 sql
SQL
1 vote115 views1 answer
Sql server today minus n
SQL
0 vote126 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
7 votes113 views2 answers
Show size database mysql
SQL
-1 vote121 views1 answer
How to change the auto increment in existing table mysql
SQL
1 vote113 views1 answer
Postgresql blocked on mac
SQL
0 vote111 views1 answer
Postgresql create user roles
SQL
0 vote112 views1 answer
Call function sql oracle
SQL
0 vote118 views1 answer
Intellij idea add mysql connector
SQL