Lab Sql

How to return data in format: Column Name t01 t02 t03 t04 Data c01 c02 c… Read more Xml Parsing On Sql Server

I need help with passing an XML path through a variable to the nodes() method. I have looked at sev… Read more Sql Variable Containing Path In Xml Node

I'm parsing an xml file but have problem with cyrillic characters: this is the relevant part of… Read more Sql Server 2014 - Parsing Xml With Cyrillic Characters

I have the following xml stored in a CLOB column in a table. I want to retrieve one value from this… Read more Extract Xml Value From Clob

I have a large XML file that I need to import and parse into tabular structure ('flatten') … Read more Importing And Parsing A Large Xml File In Sql Server (when "normal" Methods Are Rather Slow)

I have an XML that I'm trying to query with SQL. Solution 1: Add a cross apply t.c.nodes(… Read more Sql Querying Xml Attributes