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 vote274 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote286 views1 answer
Postgres copy command
SQL
1 vote284 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
1 vote290 views1 answer
Rermove categories woocommerce sql
SQL
0 vote283 views1 answer
Sql beginning of previous month
SQL
0 vote287 views1 answer
MySQL import data from large CSV file
SQL
0 vote298 views1 answer
How to search query in python3 sqlite3
SQL
0 vote286 views1 answer
Sql contains vs like
SQL
1 vote299 views1 answer
Setval pgsql
SQL
-1 vote275 views1 answer
Sql getdate date only
SQL