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 vote172 views4 answers
Sql server date format yyyy-mm-dd
SQL
2 votes207 views2 answers
Null column to 0 in mysql
SQL
32 votes153 views6 answers
Insert select
SQL
4 votes149 views3 answers
Mysql update with join
SQL
0 vote145 views2 answers
Mysql regexp match word
SQL
3 votes108 views1 answer
If 0 return null else return query mysql
SQL
0 vote142 views1 answer
Mysql group rows with same value
SQL
2 votes154 views2 answers
Mysql get time from datetime
SQL
0 vote146 views1 answer
Power query case when
SQL
36 votes170 views3 answers
Add column in mysq
SQL