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

8 votes329 views3 answers
Connect python to mysql
SQL
-1 vote265 views1 answer
How to create script to connect to oracle database and run query
SQL
10 votes326 views2 answers
Sql pagination offset
SQL
0 vote307 views1 answer
Get number of tables in database sql
SQL
0 vote257 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote323 views1 answer
Test the postgresql db connection
SQL
0 vote340 views1 answer
How to join result table in mysql
SQL
23 votes316 views4 answers
Sql server substring
SQL
2 votes392 views2 answers
Python escape string for sql
SQL
0 vote330 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL