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

7 votes309 views2 answers
Mysql default value
SQL
0 vote196 views1 answer
Sql comand for removing data from table
SQL
1 vote190 views1 answer
Oracle duration between timestamps
SQL
1 vote178 views1 answer
Mysql check table exists
SQL
10 votes234 views6 answers
Mysql set root password
SQL
0 vote189 views1 answer
Not equal to blank in mysql
SQL
1 vote204 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
0 vote179 views1 answer
Mysql add to value
SQL
0 vote188 views1 answer
Mysql create index lost connection
SQL
1 vote268 views1 answer
Oracle create program if not exists
SQL