Tags » XQuery
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
Sometimes we need sql server tables’s data(tables with Primary-Foreign key relationship) as a XML type to workout some of our need.
With the introduction of the XML datatype in SQL SERVER 2005, it provides the flexibility to generate xml type from the data contained inside sql server tables. 229 more words