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

21 votes225 views6 answers
Change column in mysql
SQL
0 vote252 views1 answer
Modifier une valeur sql
SQL
0 vote208 views1 answer
Delete insert record in sql server
SQL
0 vote214 views1 answer
Incorrect string value: mysql
SQL
0 vote222 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
6 votes220 views1 answer
Oracle rank
SQL
4 votes247 views3 answers
Sql find second highest salary employee
SQL
1 vote218 views1 answer
Calculate age in sql postgresql
SQL
1 vote227 views1 answer
Too many connections mysql
SQL
0 vote220 views1 answer
Populate db from command line postgres
SQL