All Questions
22 questions
-2
votes
1
answer
64
views
Create new tables & columns from XML data in SQL columns
I have a table in a SQL Server 2019 database with 5 XML typed columns and one key. This data is in CLIXML format. It is of course marketing information that is not within my control, and the rub -- I ...
- 13
0
votes
2
answers
165
views
How to delete node from XML column in DB
I am trying to remove a particular "node" from an XML column in my SQL Table.
Below is an example of one of the XML column contents.
<GodBrandConfig>
<AppSecret>hello</...
- 227
0
votes
1
answer
190
views
How to add xml attribute to all nodes of xml document?
I have a db table called XmlDocument with XML field, which is used to store the xml. And this is a example of stored xml:
<ol type="decimal" id="id-a4bb3b6d-9908-4972-8b02-...
1
vote
1
answer
87
views
SQL DML - unable to use the after function in modify
I need to update around 1000 xml records with a new xml node, the xml's are stored in a sql table column, with xml datatype, So I've been trying to utilize the modify function documented HERE (...
- 13
0
votes
1
answer
549
views
Modify XML in SQL field stored as Varbinary
My XML is stored as varbinary in a field.
SELECT cast (inboxXml as xml) FROM globalDB.Inbox WHERE inboxCId = '207435-N'
I would like to update one attribute (below). However the error is "Cannot ...
- 109
0
votes
1
answer
69
views
about SQL Server xml dml
I want insert into two element in if statements，for example：
x.modify('insert if (/a)>1') then element **a{1} b{1}**
…………………………
a{1} b{1} is not allowed together.
please tell me how to deal with ...
- 27
0
votes
0
answers
68
views
Server memory to process xml
I'm calling my stored procedure about 2.500 that work with xml file stored in the column using the functions (this function are xquery):
exist, modify, value
My code:
IF(@Data.exist('(Incumbent/...
- 101
0
votes
1
answer
1k
views
How to pass index value from a node in XML DML with SQL
Starting with XML DML in SQL Server, pretty fine at the moment, but I am facing this challenge. I need to iterate through some defined nodes in XML data stored in SQL Server.
Already check this as ...
- 87
0
votes
2
answers
43
views
Update Xml Field with replace value of (XML DML)
I face the situation to update an xml field data with mutliple rows within it.
The XML looks like this ( a cart data containing multiple items )
<cart>
<items>
<ItemId>...
- 1,396
4
votes
1
answer
502
views
Update XML with value from another (non-xml) column in T-SQL
I have a table with two fields of type NUMERIC and one field of type XML. Here is a rough sample:
CREATE TABLE books (
ID INT NOT NULL,
price NUMERIC(4,2),
discount NUMERIC(2,...
- 2,228
3
votes
4
answers
3k
views
Find and replace just a part of a xml value using XQuery?
I have an XML in one of my columns, that is looking something like this:
<BenutzerEinstellungen>
<State>Original</State>
<VorlagenHistorie>/path/path3/test123/...
- 2,439
4
votes
1
answer
8k
views
Error: The target of 'replace value of' must be a non-metadata attribute or an element with simple typed content
I have the following xml field in which I need to replace the value of one of the nodes:
<DataFormItem xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-...
- 53
0
votes
3
answers
400
views
Data management with an Excel Access interface
What would be the best approach on building a data management system using both excel and access?
I'm working with enough data to make it impossible to handle it alone with excel, still, I need the ...
4
votes
1
answer
11k
views
How to use XML.modify 'replace value' with a WHERE clause
I have an XML column that contains foreign key ID values stored within XML. I need to be able to update the XML when the ID value changes (e.g. change all instances of "26" to "999").
From my ...
- 9,641
2
votes
1
answer
121
views
Modifying values of XML nodes with XML DML in SQL queries
I am trying to modify node values within an XML database field using XML DML within a SQL query.
Say my table field has xml something like this:-
<ContentTree>
<ContentObject>
<...
- 137