Stack Overflow
Stack Overflow

Questions tagged [xml-column]

24 questions
0
votes
1 answer

Select 2nd row in XML Column in database using SQL

Having trouble selecting a specific info from an XML Format in a column of a table in the database. I need to pull the Success message for ModuleID 959 SubmissionID ModuleID CreatedOn XMLCOL UpdatedOn 25 959 1-1-22 "see XML…
Just Browsing
  • 61
  • 8
0
votes
0 answers

Extract and format table from a Postgres XML column with XPath

I tried for many days but to no avail. to I have an XML column called of_xml in a PostgreSQL table called s.dict. It looks like this:
Felipe Zapata
  • 1
0
votes
2 answers

Convert SQL update query to c# LINQ code

I want to convert this SQL query to C# code: UPDATE Layouts SET LayoutDetails.modify('delete /ColumnLayout/LayoutColumns/Column[@PropertyId = sql:variable("@propId")]') WHERE LayoutId = 236 This query deletes a node in a XML column in a SQL…
Sparrow
  • 355
  • 4
  • 19
0
votes
1 answer

Alter text from XML field before inserting into Oracle

I have a column which has data in XML format. I am creating a view based on that XML data. The code for taking data from XML and sending to view looks similar to below code. My original code has 120-150 columns. CREATE VIEW Test.TEST_VW ( …
user1630575
  • 171
  • 1
  • 15
0
votes
1 answer

Get part of message from LOB content

I have some XML content(less than 2000 bytes) in a LOB (Large OBject) column. I have used dbms_lob_substr(messagebody) to get the actual XML content but I need to get the exact value of a particular node. eg. xyz
Anandan
  • 353
  • 3
  • 17
0
votes
1 answer

extract datav values for XML column with XML namespaces in SQL Server

Can anybody please help me with the below xml. I need extract all the xml values like below. AwarYear Comments FieldCode FieldNumber Key Value AY2013-14 AAI: Adjusted Available Income AAI 306 …
user1884094
  • 3
  • 2
0
votes
2 answers

Why does the inclusion of an XML column in a SELECT query have such a radically negative effect on query performance?

I've been struggling with a query performance issue for a few weeks now. At this point I've squeezed absolutely everything out of the query in terms of JOIN types, Indexing, Keeping Statistics up to date, etc... etc... but then I stumbled on…
Eoin Campbell
  • 43,500
  • 17
  • 101
  • 157
0
votes
1 answer

T-SQL XML to retrieve attribute value and the respective element value

I have an XML column in a table. This column is called UserDef. The Xml looks like this: 002 AUT XYZ ABC
FMFF
  • 1,652
  • 4
  • 32
  • 62
-1
votes
1 answer

SQL(MSSQL/MariaDB) or NoSQL(MongoDB): XML search and processing

Current project situation. Get lot of XML from outside system whose size is less than 50KB and if it contains an attachment, the size would be around 5MB MAX. XML structure complexity is medium because of inner nested elements. There are ~70 first…
NGR
  • 1,230
  • 2
  • 15
  • 44
1
2