Syntax for XML query in SQL

0Comments

Use the following

SELECT Doc.value('data((/OrganisationAccountOpeningForm/KYCCustomer/EntryDate)[1])','datetime')

or syntactically

SELECT <XML Column Name>.value('data((/<XPATH>)[<1-based index into possible values returned>])','<Format to convert the XML value into>')

Enable SQL CLR in TSQLIf you need to enable SQL CLR and can't get at the Surface area configuration tool. EXEC sp... Beware: XmlSerialization via a StringBuilder/StringWriter is not compatible with XPath I recently wanted to use XmlSerialization for bi-directional conversion of data, but unfortunately w...CLR integration - SQLJust written my first C# SQL function, here it is in all its glory. [Microsoft.Sql...

	Subscribe		Contact
Archive	Facebook	Twitter

Thank you