Copy Data out of Table in an other Table within same DB

  • Thread starter Thread starter Marcel Stoop
  • Start date Start date
M

Marcel Stoop

Hi

I've got a small Problem. I want to copy several rows out of (Ms SQL) Table
A into Table B. Table A and B are the same and are within the same DB
Is that possible?

Thanks for the help

Marcel
 
Simply run a "INSERT INTO ...SELECT ..." query.

For example:

INSERT INTO tblA (Field1,Field2,...) SELECT Field1,Field2,... FROM tblB
WHERE <your condition>
 
Thanks for the help.

Marcel

Norman Yuan said:
Simply run a "INSERT INTO ...SELECT ..." query.

For example:

INSERT INTO tblA (Field1,Field2,...) SELECT Field1,Field2,... FROM tblB
WHERE <your condition>
Click to expand...
 
Back
Top