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 vote373 views1 answer
Oracle activate program
SQL
0 vote365 views1 answer
How to run mysql in git bash
SQL
1 vote407 views1 answer
Sql count value greater than
SQL
2 votes349 views1 answer
Set boolean flasksql
SQL
1 vote341 views1 answer
Postgres get timestamp
SQL
3 votes398 views3 answers
1396(hy00) mysql error
SQL
0 vote363 views3 answers
Sql query checker
SQL
8 votes361 views2 answers
Select table column name in sql
SQL
0 vote351 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
2 votes382 views2 answers
Calculate percentage in sql
SQL