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 vote149 views1 answer
Connecting mySQL to STS
SQL
4 votes128 views2 answers
How to count items with same name in sql
SQL
0 vote130 views1 answer
Calculate age in sql
SQL
1 vote142 views1 answer
Oracle sql pad left zeros
SQL
8 votes126 views2 answers
Mysql get first x characters
SQL
1 vote136 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
12 votes124 views4 answers
Install mysql ubuntu 18.04
SQL
3 votes125 views1 answer
Mssql remove column
SQL
0 vote82 views2 answers
Delete query sql server
SQL
1 vote126 views1 answer
Store select query result in variable sql server
SQL