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

0 vote304 views1 answer
Postgres float to int
SQL
0 vote348 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
9 votes377 views3 answers
Sql delete where in
SQL
0 vote342 views1 answer
The package java.sql is not accessible
SQL
1 vote337 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
2 votes316 views2 answers
Select list is not in group by clause
SQL
0 vote324 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote325 views1 answer
Mysql bind-address default value
SQL
51 votes554 views6 answers
Opera gx
SQL
5 votes319 views3 answers
Mysql extract month from date
SQL