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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marcel Stoop - 30 Oct 2005 20:11 GMT

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

Reply to this Message

Norman Yuan - 30 Oct 2005 21:16 GMT

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

For example:

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

> Hi
>
[quoted text clipped - 6 lines]
>
> Marcel

Reply to this Message

Marcel Stoop - 30 Oct 2005 21:48 GMT

Thanks for the help.

Marcel

> Simply run a "INSERT INTO ...SELECT ..." query.
>
[quoted text clipped - 13 lines]
> >
> > Marcel

Reply to this Message