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 vote128 views1 answer
Mysql Install Ubuntu with native password
SQL
-1 vote167 views1 answer
Add 10 to all numbers in a column sql
SQL
11 votes145 views3 answers
Python sqlite3 create table if not exists
SQL
3 votes135 views1 answer
Mysql UPDate with enner join
SQL
0 vote152 views1 answer
T sql dynamic top n query
SQL
-1 vote153 views3 answers
PS5
SQL
6 votes149 views2 answers
Sql query to get the number of rows in a table
SQL
17 votes135 views6 answers
Current date in sql
SQL
0 vote146 views1 answer
Renommer schema sql
SQL
0 vote166 views1 answer
Where to find pg_hba.conf in ubuntu
SQL