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 vote145 views1 answer
Opensuse status MySQL
SQL
0 vote179 views1 answer
Alter domain sql
SQL
4 votes143 views1 answer
Delete record mysql query
SQL
2 votes179 views1 answer
How to delete all duplicate items in mysql
SQL
3 votes159 views1 answer
Insert into table from another table mysql
SQL
0 vote151 views1 answer
Sql grant select only
SQL
0 vote157 views2 answers
Close external port 3306 with iptables
SQL
-2 votes145 views3 answers
Oracle tablespace usage
SQL
0 vote144 views1 answer
Mysql regex exact match
SQL
19 votes149 views5 answers
Change column name mysql command line
SQL