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

0 vote306 views1 answer
Connecting mySQL to STS
SQL
1 vote311 views1 answer
Tsql update datetime
SQL
0 vote288 views1 answer
How to put is null in where in clause
SQL
22 votes296 views4 answers
Mysql reset auto increment id
SQL
9 votes321 views3 answers
Mysql run sql file
SQL
0 vote310 views1 answer
How to delete duplicate rows in oracle
SQL
3 votes296 views2 answers
How to modify rows in SQL Server
SQL
0 vote355 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote286 views1 answer
Select last 2 characters sql
SQL
6 votes306 views2 answers
Psql load dump
SQL