xquery Questions
2
Solved
I have an XML file with the following entries:
<file>
<unit id="u-1.01"/>
<unit id="u-1.02"/>
<unit id="u-1.03"/>
<unit id="u-1.04"/>
<unit id="u-1.05"/>
...
1
Solved
I've got an XML object. And I want to deserialize it into a table using T-SQL.
<Params>
<type = 1>
<value> 10 </value>
</type>
<type = 2>
<value>...
Hillock asked 26/11, 2012 at 10:13
1
Solved
We have a fairly simple XQuery and Groovy code as follows.
Xquery code :
declare variable $criteria as element(criteria) external ;
<scopedInterventions>{
$criteria/equals/field
}</scope...
3
Solved
I would like to use a stored procedure to insert some values passed in as parameters into elements in the xml of a column. I have this so far
The following parameters:
@profile_id int,
@user_id nv...
Bestialize asked 5/11, 2012 at 14:31
2
Solved
I have a table, T1, with a XML column, EventXML, on SQL Server 2008. I want to query all the rows where certain node contains a particular value. Better, I'd like to retrieve the value in a differe...
Inconceivable asked 2/11, 2012 at 13:13
3
Solved
Is it possible to open 2 documents from an xQuery and do a join on them?
2
Solved
Sorry if this is somewhere else, I have found a lot of similar examples but I have been unable to get it working with my data. 2 days later and I need an answer :(
Basically have a SQL Server tabl...
Drunken asked 16/10, 2012 at 11:29
3
Solved
I have a table in SQL Server 2008 that it has some columns. One of these columns is in Xml format
and I want to update some attributes.
For example my Xml column's name is XmlText and it's value i...
Alimentary asked 22/9, 2012 at 17:13
2
Solved
How do I remove/ignore the XML namespace in an xml file when querying the data with T-SQL?
I’m loading an xml file into a variable, and it works just fine. But the xml has a namespace set, and unl...
Netta asked 29/3, 2011 at 2:53
1
Solved
I've tried a few things:
for $name in ('Hanz', 'Heinz', 'Hans', 'Huns', 'Hund')
where $name contains text 'Hans' using fuzzy
return $name | $name
(: returns error: Stopped at line 3, column 20: [X...
Fresher asked 17/9, 2012 at 7:3
2
Solved
Please consider the following XML--
<div id="test">
<p> Text sihdfaif</p>
<p />
<p> Text sihdfaif</p>
<p />
<p> Text sihdfaif</p>
<p&...
Toothwort asked 16/9, 2012 at 10:54
3
Solved
If I add two documents to a BaseX DB, let's say normal.xml and normal2.xml, is there a way to refer to each one individually?
I know about the doc() function, but it looks at the filesystem for th...
1
Solved
I have to generate a series of random numbers using XQuery.I found a set of libraries but those are paid.If anyone can give me a direction it would be much appreciated(preferably code).
Jost asked 23/8, 2012 at 6:36
3
Solved
I'm trying to extract monetary sums stored in some poorly formated xml columns (there is no schema defined for the XML column which I guess is part of the problem). I'm getting a conversion error w...
Phenomena asked 11/5, 2009 at 13:23
2
Solved
I have the following simple XML document:
<?xml version="1.0" encoding="UTF-8"?>
<cars>
<car>
<data attrib="Make">
<text>Volvo</text>
</data>
<dat...
1
Solved
I'm trying to query an XML column in SQL server, and I want to select records where an attribute value matches a case-insensitive string.
For instance, consider the following value for the XML col...
Revulsion asked 4/7, 2012 at 21:20
4
Solved
I need to extract (XSLT, xpath, xquery... Preferably xpath) the most deeply nested element nodes with method (DEST id="RUSSIA" method="delete"/>) and his direct ancestor (SOURCE id="AFRICA" method=...
4
Solved
I want a global variable which I can use in my different .xqy pages. Can I declare such a variable in xquery in Marklogic Server ?
1
Solved
XQuery has a set of useful functions for date conversion. But how to convert relative dates like "Today" and "Yesterday" into the actual date?
For example "Today, 17:33" should be converted to "20...
1
Solved
Below query expression:
SELECT distinct xmlCol.value('(//interest/@id)[1]','nvarchar(64)') FROM table1
Returns a list of id of first interest element of all records.
But an xml may contains mul...
1
Solved
How do I return the element sequence when shredding XML into rows in a SQL Server view?
Sample Input:
<ol>
<li>Smith</li>
<li>Jones</li>
<li>Brown</li>...
Dinnerware asked 16/4, 2012 at 9:42
1
Solved
In xquery, How to get 90 days before date from a given date?
Say given date is 30-03-2012.
I want to get the date which is 90 days before the given date. Leap year calculation should also not get ...
Barayon asked 29/3, 2012 at 20:29
1
Solved
I want to perform an update on all the rows in an XML column in SQL Server 2008, replacing just a substring in a certain xml node. I'm new to XML DML / XQuery and all that and I just cannot figure ...
Lachrymose asked 27/3, 2012 at 7:18
1
Solved
How to merge the xml content of @a and @b into @c?
declare @a xml = (select 1 aaa for xml path('AAAs'));
declare @b xml = (select 1 bb1, 2 bb2 for xml path('BBBs'));
declare @c xml = ... @a + @b ....
Violoncellist asked 19/3, 2012 at 21:41
1
Solved
I am try to implement the following code.
declare @para varchar(10) = 'b';
declare @x xml = '
<x>
<a>1111</a>
<b>2222</b>
<c>3333</c>
</x>';
sele...
Cyclopropane asked 13/3, 2012 at 17:11
© 2022 - 2024 — McMap. All rights reserved.