How do you copy rows from one table to another?

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

Previous topic - Next topic

Brandon

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

As long as there are no identity columns you can just

INSERT Table2
SELECT * FROM Table1
WHERE [Conditions]