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 vote325 views1 answer
Sql server isnull function nor working count
SQL
2 votes349 views3 answers
Sql truncate table
SQL
3 votes331 views1 answer
Oracle show trigger code
SQL
1 vote314 views1 answer
Mysql pretty date format
SQL
2 votes304 views1 answer
Mysql auto increment jumping
SQL
1 vote335 views1 answer
Select tables with name like mysql
SQL
11 votes332 views1 answer
Mysql order by two columns priority
SQL
34 votes351 views6 answers
Install mysql client ubuntu
SQL
2 votes334 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote353 views1 answer
Sql delete caracter list
SQL