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 vote197 views1 answer
Sql tablo hangi sp de
SQL
0 vote179 views1 answer
EnvironmentError: mysql_config not found
SQL
23 votes177 views6 answers
How to create table in sql
SQL
1 vote180 views3 answers
Grant syntax in sql
SQL
2 votes186 views3 answers
Mysql pass command from command line
SQL
-1 vote163 views1 answer
How to use update trigger in sql
SQL
0 vote191 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
14 votes189 views4 answers
Import database through command line
SQL
3 votes181 views1 answer
Apex set debug level
SQL
3 votes181 views1 answer
Convert sqlite table to pandas dataframe
SQL