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 vote291 views1 answer
Mysqldump: error:
SQL
0 vote291 views1 answer
What logs are available on RDS MySQL?
SQL
6 votes249 views1 answer
SQL insert all columns
SQL
0 vote274 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
0 vote294 views1 answer
Disable database droping sql
SQL
2 votes267 views2 answers
Postgresql search all tables for column name
SQL
6 votes276 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote266 views1 answer
Oracle list of long running queries
SQL
0 vote208 views1 answer
Sqlalchemy existing database
SQL
0 vote268 views2 answers
How to know the character set of an oracle databes
SQL