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

7 votes217 views4 answers
Index in mysql
SQL
1 vote210 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote194 views1 answer
Sql waitfor
SQL
0 vote189 views1 answer
How to use query in nosql
SQL
0 vote184 views1 answer
Mysql show foreign keys column
SQL
2 votes253 views1 answer
Oracle virtual column
SQL
0 vote158 views1 answer
Postgresql add leading zeros
SQL
8 votes175 views1 answer
Sql remove characters from string right
SQL
0 vote201 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote195 views1 answer
How to reset the database value in SQL server
SQL