Stack Overflow
Stack Overflow

Questions tagged [xquery-update]

Xquery-Update is for problem scenarios related to Update queries using Xquery in SQL.

using Xquery you can manage XML data-type in SQL. MSDN reference Introduction to XQuery in SQL Server 2005

74 questions
0
votes
1 answer

Writing updates to xml file with XQuery and BaseX

I have a file.xml storing protocols whose structure is the following: 1 2014-12-15 Trasmissione prospetti di…
SagittariusA
  • 5,289
  • 15
  • 73
  • 127
0
votes
0 answers

XQUERY to delete a node with an ID property in BaseX

I am using BaseX to store XML data with multiple nodes in the following format: Name of my node on the tree The code above is…
supersophisticated
  • 127
  • 3
  • 11
0
votes
1 answer

Xquery : querying xml with key value pair in t-sql

In the below code block I'm able to query till DataElements. for below xml DECLARE @xmlString XML; SELECT @xmlString=' 570 …
user3518362
  • 15
  • 6
0
votes
2 answers

Why does BaseX not modify the file upon an insert node command?

I am executing the following XQuery code on BaseX 7.9 and am able to see the insertion on the results window. I even see the new node after closing and reopening the collection. However, when I go to the file directory I see it hasn't been modified.…
popen_2
  • 43
  • 5
0
votes
2 answers

xPath expression create or modify a node

I would like to understand how to create or modify a node in a simple XML file. the following is the XML file: more…
akshitBhatia
  • 1,131
  • 5
  • 12
  • 20
0
votes
1 answer

Invoking database using xquery giving duplicate values

I am using a XQuery to query database in an OSB project. Consider the following table: userId Name Category ------ ------- -------- 1 Dheepan Student 2 Raju Student and the XQuery let $userName:=fn-bea:execute-sql( …
JPS
  • 2,730
  • 5
  • 32
  • 54
0
votes
2 answers

XQuery compare two documents and replace nodes with same name

I have a document structured like this: ... ... ... Subchildren of INVT_DATA are always elements and not text…
Brad
  • 2,261
  • 3
  • 22
  • 32
0
votes
2 answers

Xquery Multiple Results in a node

When I try to execute my Xquery Code on xml file, I am getting multiple results in one of my fields. Here is my xml file
user2133404
  • 1,816
  • 6
  • 34
  • 60
0
votes
1 answer

Replace a certain string of xml node using Xquery

I'd like to replace "~" of element with the value of element using xquery (Update facility). Is this possible? Sample.xml ace ~ card Result.xml ace ace…
user1610952
  • 1,249
  • 1
  • 16
  • 31
0
votes
3 answers

editing xml using xquery or something

I'd like to change the attribute of certain elements in an xml document. What's the simplest way? (Xquery is the best, or I can handle python somehow) Change /root/person[1]/@name to "Jim" change /root/person[2]/@name to "John" Sample.xml …
user1610952
  • 1,249
  • 1
  • 16
  • 31
0
votes
2 answers

Adding nodes using XQuery

I have 2 XML files - File1.xml Apple Pineapple Orange Banana File2.xml Grapes Peach Watermelon Chickoo I want to update/insert…
user1388575
0
votes
2 answers

XQuery Update Facility

I have got a quick question regarding XQuery update, Dose XQJ support implementing XQuery update facility to insert an element into an XML document?
Lucy
  • 471
  • 4
  • 12
  • 28
0
votes
1 answer

INSERT queries in Saxon api

Does Saxon xqj api support issuing insert queries? If No, Is there any academic article discussing this? and what alternative should be used? If Yes, is there any code example for doing so? Any answer would be highly appreciated.
Lucy
  • 471
  • 4
  • 12
  • 28
-1
votes
1 answer

What is the Venn diagram for XPath, XQuery, and XQuery Update?

Note: in all of the following, when I refer to "XQuery" I mean the latest version of XQuery. Ditto for XQuery Update. [True or False] XQuery is a superset of XPath. That is, the XQuery language consists of all the stuff in XPath plus more. Eek! I…
Roger Costello
  • 3,007
  • 1
  • 22
  • 43
1 2 3 4
5