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 vote318 views1 answer
Sqlcmd no headers
SQL
4 votes305 views3 answers
How to describe a table in sqlite3
SQL
0 vote281 views2 answers
Avg() sql
SQL
2 votes372 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote338 views1 answer
Declare or use variable in snowflake
SQL
5 votes317 views1 answer
Get table columns from sql
SQL
0 vote335 views1 answer
Cahnge column name apex oracle
SQL
2 votes307 views1 answer
Sqlite insert if not exists
SQL
19 votes313 views5 answers
Date between in mysql
SQL
0 vote318 views1 answer
Postgres clear table
SQL