Those are just aliases. Instead of Term(att), we can use a(b) or k(x) etc....

I see that the XPath expression you are using is incorrect. Also, note that XML is case sensitive. DECLARE @t TABLE (data XML) INSERT INTO @t(data) SELECT '

can you show an example that explains what exactly you are looking for?...

This post is inspired by a question in MSDN forum about disabling certain rendering formats when setting up SSRS subscriptions. This can be achieved by changing the SSRS configuration file as explained below. I never had a real-world scenario where I n...

...

FILESTREAM data can be accessed by TSQL as well as through the Win32/Managed APIs. Accessing FILESTREAM data using TSQL is not recommended for a number of reasons such as the inability to stream data when reading or writing through TSQL. The recommended...

You are absolutely right. I made a nasty mistake when I posted the original code samples. I have corrected them. Thanks for catching that....

This post is triggered by a question I recently saw in the BR Forum asking ideas for merging two XML documents. I thought of adding another installment to the XQuery Labs series to explain how this can be done from TSQL when required. The examples giv...

Pranay, Depending upon the complexity of the environment, there could be a number of different approaches you may want to select from. Based on what I understood from your post, I would suggest you use an SSIS script task to combine all the XML data ...

See [this books online page][1] which clarifies this. It says: In SQL Server, the page size is 8 KB. This means SQL Server databases have 128 pages per megabyte. Each page begins with a 96-byte header that is used to store system information abou...