InnerXML from an element selected by SQL Server's OPENXML command

Question

As a follow-up to this question - Is there a way to get the raw XML inside an element that you select using OPENXML? Should I be using an XML datatype instead? Is there a way to get the raw XML with the XML datatype?

marc_s · Accepted Answer · 2009-04-02 21:09:08Z

2

Well, with the XML datatype in SQL Server 2005 and up, you always HAVE your raw XML - no need to "get it" - it's right there, in the column, stored for your convenience.

You can of course also query it using XQuery and XPath, and even update it while it's stored inside the database!

If you can - definitely use the XML data type! You can use it "untyped" or associate it with a XML schema to add validation.

Marc

answered Apr 2, 2009 at 21:09

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

Collectives™ on Stack Overflow

InnerXML from an element selected by SQL Server's OPENXML command

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related