Tag Archives: xml

Finding the Attribute

I was playing with some Extended Events recently. If you haven’t tried, I’d encourage you to do so. However, working with XML is not my favorite. I know I can get the GUI in SSMS 16.x to show me events, … Continue reading

Posted in Blog | Tagged , ,

Basic XML Node Query–#SQLNewBlogger

  Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a question recently about querying an XML document. Certainly avoid this in the database if you … Continue reading

Posted in Blog | Tagged , , ,

Loading XML Data–CONVERT Option 2

I was playing around with some XML lately, and had to load a file that looked like this:: I ran a simple query, one that used the OPENROWSET and a CONVERT to load the data. WITH XmlFile (Contents) AS ( … Continue reading

Posted in Blog | Tagged , , | 4 Comments

Parsing SQL Saturday Data – Getting Titles from the XML document

I’m continuing on with my project to grab SQL Saturday data and automatically insert it into a SQL Server database. In this piece, I’m picking up from the last one where I had a loop to load all XML documents … Continue reading

Posted in Blog | Tagged , , ,