Jump to content

XQuery


Recommended Posts

  • 1 month later...

Hi Svendsen,

We also want to try and use XQuery, to process test reports in XML format - but first we are trying to figure out how to write the contents of an XML file into SQL Server 2005 using the XML datatype. When we tried to do this a lot of the formatting characters were removed by the Server and so the file was corrputed when we read it back out.

From what I understand it seems that with XQuery we can directly query the contents (TAGS) of an XML datatype column very efficiently - rather than say having to use the LIKE command when trying to find matches in strings.

If we can work it out I'll let you know

Chris

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.