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 vote177 views1 answer
My sql data file extention
SQL
1 vote180 views2 answers
Sql server concat string and int
SQL
0 vote189 views1 answer
Sql new line output
SQL
0 vote192 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote161 views1 answer
Limiting query result using where in sql
SQL
1 vote174 views1 answer
Mysql get last insert id
SQL
-1 vote180 views1 answer
How to change the auto increment in existing table mysql
SQL
1 vote176 views1 answer
Mysql text to decimal
SQL
0 vote237 views1 answer
Month mysql
SQL
0 vote184 views1 answer
Alter table change default
SQL