The real power of XML in SQL Server lies in its so-called xquery FLWOR expressions. I personally love to play with XML in SQL Server because it’s so powerful and easy to integrate. FLWOR is the acronym for for, let, where, order Continue Reading..
XML integration in SQL Server is always been an added advantage to T-SQL. XML is designed to meet the challenges of large scale electronic data publishing in structured format. It is widely being used for the representation of arbitrary data structures such as Continue Reading..
We often require a column values to be assigned into a variable as comma separated. For this either we would prefer to create a scalar valued function for long term purpose or write a couple of line codes to achieve Continue Reading..
So far there is no inbuilt split function available in SQL Server to split a delimited string into an array or table format. In my last article I talked about, splitting a delimited string into columns and rows. In this blog post I Continue Reading..
sp_xml_preparedocument is a Microsoft shipped extended stored procedure to parse xml document in SQL Server. In this blog post we will learn about XML shredding in SQL Server. Previously we saw how to convert tabular data into xml document. I would Continue Reading..
This is a series post on XML. In my previous post I have discussed about XML modes in SQL Server. If you are new to XML then I would recommend you to read the previous post first. You must be Continue Reading..
XML stands for Extensible Markup Language. XML is a self-descriptive document, as it contains data and metadata in a hierarchical set of tags. The data in XML can be either in form of attributes and/or elements with proper tags. Data Continue Reading..
I was been searching for a solution to compare two XML data in SQL Server, then finally ended up using a great function written by Jacob Sebastian. This function returns 1 if it does not match, and returns 0 in identical case. However Continue Reading..
Often we come across to a point where we need the data to be unpivoted. SQL server has Pivot and Unpivot clauses in built though but that’s little difficult to use when we don’t have any aggregation to do. By Continue Reading..