Top "Xquery-sql" questions

selecting individual xml node using SQL

I have a large XML note with many nodes. is there a way that I can select only a single …

sql-server sql-server-2005 xquery-sql

Learning XQuery() in SQL server

SQL server 2008 sp2 I am a beginner and finding that XQuery syntax especially XPath very challenging. For e.g. trying …

sql-server sql-server-2008 xquery-sql

Add node to XML using TRANSACT-SQL

I've been struggling with this simple piece of code without result. I'm just trying to add a new node to …

sql-server xml tsql xquery-sql

Sql Xquery How to Replace text in Update Query

Table is named as MasterTable Columns ID type BIGINT, Name type VARCHAR(200) (stores xml type data for some reasons) Name …

sql-server sql-update xquery-sql xquery-update

Updating XML attribute in SQL Server XML column

I am trying to update a node of in my XML which is stored in a SQL Server XML column, …

sql sql-server xml xquery-sql

Compare two sets of XML data using XQuery in SQL Server

Suppose I store employee data in a xml column in my log table. Sometimes data is also updated in the …

sql-server-2005 tsql xquery-sql

Parsing XML with namespaces in SQL Server

I am having a hard time trying to parse an XML that has some namespaces defined: <TravelItineraryReadRS xmlns:xsi="…

sql xquery-sql

select multiple nodes xml

I'm retrieving xml formatted text from ntext fields (sample format of a row below): <root> <DocInfo> &…

sql-server xml sql-server-2008 xquery-sql

xQuery LIKE-operator (starts-with)

Value in the field is as follows <en-US>Parameter23</en-US> <it-IT>Parameter</it-IT&…

xml sql-server-2005 where-clause sql-like xquery-sql

XQUERY - How to use the sql:variable in 'value()' function?

The query below is trying to select a child node of a given Node. How do I use a variable …

sql sql-server sql-server-2008 xquery-sql