Print Page - How do you copy rows from one table to another?

Title: How do you copy rows from one table to another?
Post by: Brandon on October 22, 2014, 10:42:27 PM

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.

Title: Re: Copy rows
Post by: Bentley on 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]

Webastor - Programming Tips and Tricks