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

1 vote368 views1 answer
Database Queries
SQL
2 votes362 views5 answers
Install postgresql 10 centos 7
SQL
1 vote324 views1 answer
T-SQL Alter the column data type
SQL
0 vote330 views1 answer
Sql server express download
SQL
5 votes318 views2 answers
Ranking functions in sql
SQL
0 vote318 views1 answer
What is the essence of SQL?
SQL
0 vote365 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote346 views1 answer
Update and keep original value sql
SQL
0 vote364 views1 answer
Oracle swap partition
SQL
20 votes322 views2 answers
Counting in sql
SQL