Answers for "tsql insert from select"

SQL
5

insert select

INSERT INTO table2
SELECT * FROM table1
WHERE condition;
Posted by: Guest on June-30-2020
11

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;
Posted by: Guest on May-02-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language