Short for 'eXtensible Markup Language.' A textual markup language for transferring structured data.
1
vote
0answers
75 views
XML parsing failed
I'm using a query on a oracle db which extracts values from clobs using the xmltype function and an xpath. Unfortunately the query fails and reports a 'XML Parsing failed'. I assume that one of the ...
0
votes
2answers
326 views
how to select * from XML where id=1?
declare @xml xml,
declare @num int
set @num = 1
set @xml = '
<row>
<Id>1</Id>
<name>reza</name>
</row>
<row>
<Id>2</Id>
...
0
votes
1answer
58 views
Query not returning items in the original order
Consider the following set, which is the content of the table variable @ProductContent that was just created for the query that runs against it:
Notice how items are sorted by media_type_id, ...
0
votes
1answer
111 views
avoid insert xml duplicate data
how can to prevent duplicate inserts for every Execute?
insert into IQ (XMLDT)values('<row>sdsdf</row>')
0
votes
1answer
121 views
Parse message_body(XML)
I know the contents of @message_body are:
<inserted DocNo="xxxx99999"/>
I want to put 'DocNo' into a variable I created @DocNo and have tried various this such as:
SET @DocNo = (SELECT ...
0
votes
1answer
178 views
How to convert data from XML format into Excel workbook or database table [closed]
I have some data that is given in a consistent XML format (which I can't change). I would like to import it into a database so that I can work with it, and then search, identify and export certain ...
0
votes
2answers
262 views
SQL Server XML Insert Optimize?
I have a 400k XML document trying to insert into an 86-column SQL Server 2008 table.
It takes about 35 minutes to get that XML into a temp table using this code:
with XmlNamespaces ( ...
0
votes
3answers
46 views
Built-in XML functions
I am trying to use built-in XML functions, but I'm getting an %s: invalid identifier error. Selects works fine without the XML functions.
Any ideas where is the mistake?
select id,full_name from ...
0
votes
1answer
224 views
Returning Multiple Result-Sets or Single XML Blods
I've been writing some new Stored Procedures, and find myself returning between 6-8 result-sets in a few cases. I've always worked under the assumption that there were certain inefficiencies with ...
0
votes
0answers
94 views
How to create table set from several XSD in SQL Server 2012 or with VS 2012
Is there any solution in T-SQL or in C# how to create XML schema collection in T-SQL or C#?
Problem is I cannot use:
USE Database_test
GO
CREATE XML SCHEMA COLLECTION Collection_from_XSD AS
N'
...
0
votes
0answers
43 views
XML Data convert to SQL database,
I have an XML feed that i need to parse daily, i want to store all of the data from the XML feed in a SQL table so then that data can be queried and manipulated by my clients.
I can currently parse ...
0
votes
1answer
97 views
What is the best way to insert a XML input to an oracle table in stored procedure?
I want to write a stored procedure which has a XML input (clob type) and inserts the data to a table. my XML structure is something like this:
<rowset>
<row>
...
0
votes
0answers
28 views
dtd restrictions [closed]
I am making a xml for a survey taken by students in a class. My dtd of responses looks like this:
<!DOCTYPE responses [
<!ELEMENT responses (student)+>
<!ELEMENT student (response?)>
...
0
votes
0answers
208 views
Identifying XML Node Position in SQL Server 2008
I am having a problem identifying the node position that contains a particular element in a piece of XML.
In the example below I would like to extract the position for each node within the statements ...
