Short for 'eXtensible Markup Language.' A textual markup language for transferring structured data.
2
votes
1answer
921 views
Best methods for ingesting XML into Oracle 11gR2
I have a large Oracle 11g Instance. I now have a requirement to convert large amounts of XML into records in several related tables.
The xml will arrive frequently at irregular intervals. The ...
2
votes
1answer
1k views
Is this a good way to store XML data in SQL SERVER 2008?
I'm doing a feasibility study for storing data in the following structure with SQL SERVER 2008:
-MYTABLE
|ID|RECORDS|BRANCH_OFFICE|MONTH|YEAR
The RECORDS column has the XML data type and it will ...
2
votes
1answer
179 views
Where can I find information on shredding xml with .nodes?
I recently saw this answer on SO which uses the "local-name" value while shredding xml using .nodes(). I've never seen this before:
select T.N.value('local-name(.)', 'varchar(128)') as Name,
...
4
votes
2answers
162 views
How do I track the usage of XML indexes?
My XML indexes are not listed in sys.dm_db_index_usage_stats
Does this mean they aren't being used? Or does this particular DMV not track XML index usage? (Books Online doesn't appear to answer the ...
1
vote
2answers
2k views
SQL Xml returning empty root tag on empty record set
I am working on xml explicit to generate user defined nodes in xml output using Sql Server 2005 Express edition. The below code works fine, just that i couldn't manage to generate a empty node when ...
2
votes
2answers
678 views
SQL statement to combine main table and child table as columns?
Having a main table and a child table in a Microsoft SQL Server database (2005+), I want to show the user a single table in a grid view which includes rows from the main table and rows from the child ...
3
votes
2answers
2k views
stored proc to handle XML as input param for multiple record inserts
i have updated my proc from taking typical data types to take a single XML param so that i can call it once instead of multiple times for inserting multiple records.
here is a sample of my proc that ...
10
votes
4answers
3k views
When to use XML data type
I'm responsible for creating a database on a project. We have fields that are rarely going to have a value (1 in every 10,000 records) and I'm trying to work out the best way to store this in the ...
1
vote
1answer
609 views
Select statement to retrive xml output as below
Hi could someone provide me some clues or solution to retrive record sets like below
note: i read the msdn documentation but leads me no where but hair loss :(
Just for the assumption think i have 2 ...
3
votes
2answers
1k views
Select XML values when attribute involved
I have a table that stores XML values in field: OtherData.
An XML value from one row:
< file path="C:\WINDOWS\system32\svchost.exe" />
I would like to select all rows that have an ...
4
votes
3answers
2k views
How to insert multiple records using XML in SQL server 2008
i use SQL server 2008 in my web application back end. Apparently i iterate through all the records from the C# code whenever there is a multiple insertion scenario. i have never tried the multple ...
5
votes
3answers
11k views
Read XML file in SQL Server 2008
How can I read an XML file and store the data in XML to our table in SQL Server 2008?
3
votes
1answer
8k views
trying to turn XML into heirarchical SQL tables, can anyone provide a good explanation of two parts of this code example?
I am trying to learn how to turn XML into heirarchical SQL tables.
I have found an old code snippet from a Microsoft forum which is basically what I am trying to do, but I was wondering if someone ...
4
votes
1answer
519 views
What is the difference between these two create table statements?
a)
SQL> CREATE TABLE xml_tab1(poDoc XMLTYPE);
Table created.
SQL> desc xml_tab1;
Name Null? Type
----------------------------------------- -------- ...
2
votes
1answer
221 views
Using CoreData on a client-side application
This may be a bit more of an SO question, but...
If I'm writing a client-side application for OS X that's going to sync with an online MySQL database, is there any difference on if I have CD use ...
