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 vote276 views1 answer
Restart identity postgresql
SQL
3 votes350 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote321 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
1 vote330 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote336 views2 answers
Py sqlite if entry exists
SQL
2 votes316 views1 answer
Possgress drop if exists table
SQL
0 vote363 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote338 views1 answer
Sql put two columns into one
SQL
2 votes320 views1 answer
Copy all values of a column to another column in sql in same table
SQL
9 votes337 views6 answers
Check constraint in sql
SQL