Export - best way to export XML in an XML field to a file ..

I'm trying to figure out the best way to automatically export two
fields to a file from a table. The first is a bigint column (the ID
field for that row), the second is datatype XML, containing XML data.
The goal is to save the data out from the table, delete the contents
from the table, but with the ability to readd it later if needed.

Any help greatly appreciated.
M

Am Wed, 31 Dec 2008 14:45:07 -0800 (PST) schrieb M Bourgon:

> I'm trying to figure out the best way to automatically export two
> fields to a file from a table. The first is a bigint column (the ID
> field for that row), the second is datatype XML, containing XML data.
> The goal is to save the data out from the table, delete the contents
> from the table, but with the ability to readd it later if needed.
>
> Any help greatly appreciated.
> M

You can do this with BCP. Just g**gle for "bcp write xml" or
"bcp read xml column" and you will find a lot of examples.

bye,
Helmut