How do you copy rows from one table to another?

Started by Fabio, October 22, 2014, 10:42:27 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Brandon

October 22, 2014, 10:42:27 PM Last Edit: February 19, 2018, 08:02:32 PM by Sofyene
Hi everyone, I would like to ask you a quick question. Thank you How we do, how do you copy rows from one table to another? Please help me Help.

Bentley

#1
February 19, 2018, 08:03:15 PM
As long as there are no identity columns you can just

INSERT Table2
SELECT * FROM Table1
WHERE [Conditions]
Print
Go Up Pages1
User actions