Posts Tagged ‘sql server 2008’

Querying SQL Server XML data

Posted: 18th March 2010 by thegrayzone in Development
Tags: , , ,

Today I was working with data stored using SQL Servers XML datatype. I had to find a way of dealing with the XML data like you would standard relational table data. Here’s how to do it. Sample table and data Firstly, here is a basic table to store the data: CREATE TABLE DummyTable ( DummyTableID [...]