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

-1 vote353 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote362 views2 answers
CREATE OR REPLACE FUNCTION
SQL
1 vote341 views1 answer
Mysql batch insert
SQL
0 vote404 views1 answer
Postgres - Login and connect as default user
SQL
1 vote340 views1 answer
Media sql
SQL
0 vote340 views1 answer
Ignore case in string sql
SQL
1 vote347 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote402 views1 answer
Mariadb disable foreign key checks
SQL
0 vote372 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
1 vote336 views1 answer
How refresh navicat tables to see new tables
SQL