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
– Jeremy, Commented Mar 4, 2011 at 19:12

Community · Accepted Answer · 2017-05-23 12:11:52Z

0

Look, here

Essentially you want to extract text from varbinary.

edited May 23, 2017 at 12:11

CommunityBot

11 silver badge

answered Mar 4, 2011 at 4:27

Ryk

3,1025 gold badges30 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jeremy Over a year ago

that requires client software to be built. No way to do it with a query?

Collectives™ on Stack Overflow

extract xml from image column in sql server

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related