SQL Server supports a subset of the XQuery language. One of features implemented within SQL Server XQuery are comparison operators. There are two kinds of comparison operators: 285 more words
Tags » XQuery
DECLARE @x XML = N'
SELECT a.XmlCol.query('.') AS CurrentElement, 79 more words
A link to a blog that can be used as the starting point for those who need to manipulate XML held in MS-SQL.
Large data mostly involvs Xml Contents. One can query Xml content in SQL Server management studio (SSMS) when he xml is small. Imagine there is a very large XML file , opening the xml file for edit and pasting the content of the xml file in SSMS new query window is tedious and cumbersome. 1,176 more words
Long time no post, so here’s a new (short) article.
Behind the cryptic title lies a situation like this :
<root> <id>1</id> <name>SMITH</name> <id>2</id> <name>WILSON</name> <id>3</id> <name>GRANT</name> </root> … 632 more words