A few weeks back, I published a function named XMLTable() that helps to query XML documents easily. The idea behind the function is to be able to blindly query XML documents just like you do a ‘SELECT *’ on a relational table. Not only that this function helps you to query XML documents easily, it......

A few weeks back, I published a function named XMLTable() that helps to query XML documents easily. The idea behind the function is to be able to blindly query XML documents just like you do a ‘SELECT *’ on a relational table. Not only that this function helps you to query XML documents easily, it......

This is the 15th year in my career building serious business applications using various technologies (starting from DBase, going through Clipper, Foxpro, Visual Basic, Visual C++, and finally sticking to SQL Server) and one of the points I observed is that most end users can't work with a fixed set ......

In the previous post, we saw a basic example that reads information from an XML document using OPENXML(). In this post, we will focus on reading information from XML documents having namespace declarations. Here is a simple example: DECLARE @x VARCHAR(8000)
SET @x =
'
'
DECL......

This post intends to help you get started with OPENXML() function. OPENXML() lets you shred an XML document or fragment into a result set. Though OPENXML() has got no direct relationship with XQuery, I thought of including it in the XQuery Labs series for completeness. Just like XQuery, OPENXML() ......

One of the questions that might come to your mind while getting started with FILESTREAM is the way FILESTREAM directories and files are named. Within the FILESTREAM Data Container, SQL Server creates a root folder per FILESTREAM enabled table. If the table is partitioned, a folder will be created fo......

I was very much surprised to see a fabulous review of my book ‘The Art of XSD – SQL Server XML Schema Collections’ by Hima Vejella, a well known .NET expert, author and speaker from the Microsoft Most Valuable Professionals (MVP) community. It took me around 18 months to complete the book and when ......

Chennai SQL Server User Group, in association with PASS is proud to host the 1st biggest SQL Server event in Chennai. Speakers are from the Microsoft Most Valuable Professional (MVP) community and it provides excellent opportunity for people to interact with renowned industry experts. ......

I think it will be quite common that you try to insert a UNICODE value into an XML document and then you see that the INSERT did not work correctly because the value you find within the XML document is slightly different from what you inserted. I got a similar question recently and thought of adding......