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

12 votes167 views2 answers
Insert multiple rows from another table sql
SQL
0 vote181 views1 answer
Oracle concat datetime
SQL
0 vote234 views1 answer
Order by number of character in sql
SQL
0 vote181 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote172 views1 answer
Reona
SQL
0 vote201 views2 answers
Sql update multiple tables
SQL
2 votes155 views1 answer
Oracle cpu per session
SQL
2 votes213 views1 answer
Mariadb json select
SQL
0 vote169 views1 answer
Mysql update privileges
SQL
1 vote191 views2 answers
One to one and one to many relationship
SQL