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

1 vote211 views1 answer
Find a column in all tables postgres
SQL
1 vote163 views1 answer
Ms sql how to see active job current run time
SQL
0 vote260 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote208 views1 answer
Sql server datetime to string
SQL
0 vote192 views1 answer
Psql select * from table
SQL
0 vote213 views1 answer
Sqlserver now
SQL
1 vote201 views1 answer
Mysql best tutorial for beginners
SQL
2 votes198 views1 answer
How to delete view in sql
SQL
0 vote238 views2 answers
Mysql show foreign keys
SQL
5 votes199 views1 answer
Oracle ora-00054 causes
SQL