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 vote192 views1 answer
Define a variable in mysql from select
SQL
0 vote176 views1 answer
Migrations.RunSQL
SQL
2 votes170 views2 answers
Useradd postgres
SQL
0 vote210 views1 answer
Postgres list all triggers
SQL
0 vote163 views4 answers
How to drop all tables in sql
SQL
0 vote182 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote179 views1 answer
How many rows affected in sqllite
SQL
5 votes171 views1 answer
Oracle asynchronous update
SQL
0 vote173 views1 answer
Postgresql isnull with max
SQL
1 vote170 views1 answer
Stop mysql server mac
SQL