Sql server insert into select

Insert into values select

INSERT INTO my_table SELECT * FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table s
	WHERE s.my_col >= 10;

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

Sql server insert into select

INSERT INTO table2
SELECT * FROM table1
WHERE condition;

SQL Server INSERT INTO SELECT

 INSERT INTO table1
 SELECT col1, col2 , col3 FROM table2
 WHERE your condition;

Source: naycode.com

SQL Server INSERT INTO SELECT

 INSERT INTO salesTransaction_History
 SELECT * FROM salesTransaction
 WHERE item_Number='Salt-1';

Source: naycode.com

Similar codes

1 vote129 views2 answers
Populate sql table with random data
SQL
79 votes302 views6 answers
Grepper code
SQL
0 vote146 views1 answer
Mysql utc timestamp
SQL
0 vote149 views1 answer
Add computed column to table sql server
SQL
15 votes212 views3 answers
Postgresql change column type
SQL
32 votes128 views6 answers
Insert select
SQL
11 votes123 views3 answers
How to get last row of table in sql
SQL
0 vote120 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote131 views1 answer
Sintaxis SELECT sql
SQL
1 vote144 views1 answer
Sqlite update from another table
SQL