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 vote372 views1 answer
Mysql exception output
SQL
0 vote372 views1 answer
How to change null display in psql
SQL
1 vote393 views1 answer
Mysql select row max date
SQL
0 vote383 views1 answer
Alter table change default
SQL
5 votes417 views1 answer
Mysql count lines
SQL
33 votes371 views6 answers
Change column name in mysql
SQL
0 vote364 views1 answer
Mysql create pool
SQL
2 votes361 views1 answer
Oracle drop table free up space
SQL
2 votes339 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote391 views1 answer
Sql max of two values
SQL