xquery-sql

相关标签：javascript jquery android 多少钱 iPhone

How to extract values from XML without hard coding names of elements using XQuery in SQL Server?

I have xml stored in a table and table with names/paths of the elements I am interested in. I would like to extract values of these elements without hard coding paths and/or names of the elements. S[详细]

2023-03-19 16:50 分类：问答
SQL Server XML add attribute if non-existent

I am trying to add an attribute if it does not exist. It should be simple, but I am new to XML XPath/XQuery/etc., so excuse my ignorance.[详细]

2023-03-16 14:49 分类：问答
Update XML field with no text in T-SQL

I\'ve come across a problem in updating an SQL field in that what I\'ve written works perfectly for xml nodes with a text present, however it trips up when the node is empty.[详细]

2023-03-11 14:44 分类：问答
MSSQL 2008 get all levels of item

say I have xml in a SQL xml type field e.g. @x=\'<root> <item> <title></title> <item>[详细]

2023-03-11 00:47 分类：问答
Concatenate specific attribute of all elements together with xquery

How 开发者_StackOverflowcan I concatenate a specific attribute of all elements together using SQL XQuery?[详细]

2023-03-09 05:28 分类：问答
Find child where parent IS NOT a certain element

I\'d like to find an empty organisation element where it is not the immediate child of a parentProblem element.[详细]

2023-03-08 03:47 分类：问答
The best way to extract data from xml with xquery

Consider the following xml: <Persons num=\"3\"> <Person age=\"5\" /> <Person age=\"19\" />[详细]

2023-03-07 01:19 分类：问答
Getting the data of Ancestor node + XQuery-Sql

This is how my XML looks like : <Product sequence_number=\"1\" number=\"1543448904\" id=\"S1\" unit_number=\"1\">[详细]

2023-03-03 05:46 分类：问答
How to replace a part of XML node in SQL Server 2005

I would like to know how I can update a part of the text of an XML node in SQL Server 2005 u开发者_如何学Csing xquery[详细]

2023-03-02 17:44 分类：问答
SQL Server Query XML in Nvarchar(max) Field?

I have XML stored in an nvarchar(max) field.I realize there is an XML data type, but in this case it开发者_如何学JAVA is not stored that way. Let\'s say the XML is structured like the following:[详细]

2023-02-24 11:20 分类：问答