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 vote222 views1 answer
Online sql compiler
SQL
1 vote271 views1 answer
Sql Split string function
SQL
0 vote273 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote285 views1 answer
Print hello world in plsql
SQL
0 vote251 views1 answer
Get all employees if name ends with in sql
SQL
0 vote329 views1 answer
Calculer pourcentage mysql
SQL
0 vote280 views1 answer
Mysql get only the field names in a table
SQL
1 vote276 views1 answer
PL SQL MODIFY COLUMN NME
SQL
3 votes277 views1 answer
Postgresql db owner change
SQL
0 vote255 views1 answer
Select other columns with distinct
SQL