Author Topic: How do you copy rows from one table to another?  (Read 337 times)

Offline Brandon

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
How do you copy rows from one table to another?
« 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.
« Last Edit: February 19, 2018, 08:02:32 PM by Sofyene »



Offline Bentley

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Re: Copy rows
« Reply #1 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]


 

Sitemap 1 2 3 4 5 6 7 8 9