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

4 votes122 views1 answer
Wilayah indonesia sql
SQL
0 vote140 views1 answer
Reset postgres table index to next max value
SQL
0 vote117 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote116 views1 answer
Snap craft
SQL
0 vote112 views1 answer
Mysql select all where count more than"
SQL
61 votes284 views6 answers
Mysql add column
SQL
0 vote115 views1 answer
Top frequency in sql server
SQL
0 vote142 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote139 views1 answer
Synapse sql table set pk
SQL
1 vote104 views1 answer
What is int in mysql
SQL