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

2 votes251 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
5 votes235 views3 answers
Day of week postgresql
SQL
3 votes302 views1 answer
Mysql cli connect with password
SQL
12 votes233 views2 answers
Delete all nodes neo4j
SQL
5 votes233 views1 answer
Alter table add comment oracle
SQL
7 votes240 views1 answer
Sql server convert string to date
SQL
7 votes222 views4 answers
How to reset the identity column in sql server
SQL
1 vote240 views1 answer
Mysql copy table1 to table2
SQL
1 vote231 views1 answer
Sql list all procedures
SQL
23 votes258 views4 answers
Uninstall postgresql ubuntu
SQL