extract xml from image column in sql server

Question

I have some xml documents stored as an image data type in a sql server 2000 table. How can I extract the data back to xml and save to a file, or at least see the xml contents in the query window, using just the sql tools?

Because the database also stores binary data in some cases. Currently I am only interested in the records that have xml data — Jeremy, Mar 04 '11 at 19:12

score 0 · Accepted Answer · edited May 23 '17 at 12:11

0

Look, here

Essentially you want to extract text from varbinary.

edited May 23 '17 at 12:11

Community

1
1

answered Mar 04 '11 at 04:27

Ryk

3,072
5
27
32

that requires client software to be built. No way to do it with a query? – Jeremy Mar 04 '11 at 19:13

extract xml from image column in sql server

1 Answers1