sqlxml Questions
3
Solved
is there any chance of getting the output from a MySQL query directly to XML?
Im referring to something like MSSQL has with SQL-XML plugin, for example:
SELECT * FROM table WHERE 1 FOR XML AUTO
...
4
Solved
i have a table that contains an XML column:
CREATE TABLE Batches(
BatchID int,
RawXml xml
)
The xml contains items such as:
<GrobReportXmlFileXmlFile>
<GrobReport>
<ReportH...
Yucca asked 5/2, 2013 at 17:2
4
Solved
I have a table that contains a Xml column:
SELECT *
FROM Sqm
A sample of the xml data of a row would be:
<Sqm version="1.2">
<Metrics>
<Metric id="TransactionCleanupThread.R...
Belda asked 3/10, 2013 at 17:13
2
Solved
I see that Oracle, DB2 and SQL Server contain a new column XML. I'm developing using DB2 and from a database design you can break the 1NF if the xml contains a list.
Am I wrong to assume that SQLX...
Stepsister asked 15/6, 2016 at 15:1
1
Solved
Using sql server 2012 sp1 I haven't been able to find a solution out there but I believe that its not possible to add xml block into specific position of an existing xml column in a table. For exam...
Smarten asked 14/3, 2016 at 3:27
1
Solved
TLDR;
I am attempting to use SQLXML Bulk Loader (4.0) to load XML that looks something like this;
<?xml version = "1.0" encoding = "UTF-8"?>
<CarSales>
<Client>
<ID >3&l...
Fir asked 8/9, 2015 at 19:9
1
Solved
Assuming I have a table data as below:
I want to Select all Value(XML Data) which contains the node Name="Hello World". How can I achieve it?
SQL Fiddle
set @f = @XML.exist('/ArrayOfFilterColumn...
Reportage asked 13/3, 2015 at 6:20
2
Solved
What I Have
I have a variable size XML document that needs to be parsed on MSSQL 2008 R2 that looks like this:
<data item_id_type="1" cfgid="{4F5BBD5E-72ED-4201-B741-F6C8CC89D8EB}" has_data_ev...
Intellectualism asked 13/6, 2014 at 1:44
3
Solved
I know that I can search for a term in one column in a table in t-sql by using like %termToFind%. And I know I can get all columns in a table with this:
SELECT *
FROM MyDataBaseName.INFORMATION_...
Touchmenot asked 30/8, 2013 at 12:26
2
Solved
I would like to know, how can I load the XML content from an arbitrary file into a local variable?
This works for a fixed file:
DECLARE @xml XML
SET @xml =
(
SELECT *
FROM OPENROWSET(BULK 'C:\...
Aweigh asked 16/12, 2013 at 13:16
1
Solved
I am generating a XML file from a SQL Server query.
I have some problem about sorting elements issues.
For example, there is simple code as below.
<test>
<tree abc="123"/>
<tree...
Rysler asked 16/12, 2013 at 14:21
5
I've tried using "FOR XML PATH", "FOR XML EXPLICIT" and "FOR XML AUTO" but the data is never structured with the correct heirarchy.
Basically, I have one parent table (Customers) and 3 child table...
Hayse asked 29/6, 2012 at 10:28
2
Solved
I have a table with the data:
itemID itemLocation quantity
-------------------------------------------------------
B008KZK44E COMMITED 1
B008KZK44E PRIME 1
B008KZK2LE COMMITED 1
I need to genera...
Caruncle asked 10/10, 2013 at 16:17
2
Solved
I have a SQL query that returns me the XML below
<row>
<urlSegment>electronics</urlSegment>
<shortenedUrlSegment>0x58</shortenedUrlSegment>
</row>
<row>...
Menticide asked 18/9, 2013 at 5:25
1
Solved
Using SQL 2012 & getting XML passed into a stored procedure that must take that input & write a row to the table for each of the items that is in a section of the XML that is passed to the ...
Kostroma asked 26/9, 2013 at 17:8
1
Solved
This is my sample XML:
<root>
<element>
<subelement>
<value code="code1">value1</value>
<value code="code2">value2</value>
</subelement>
</...
Autography asked 3/9, 2013 at 7:41
2
Solved
I have a table of hierarchical data that I am trying to select as a single, grouped XML value:
Columns: Id, Type, SubType, SubSubType
Sample data:
Id Type Subtype SubSubType
1 Product Documentat...
Warnke asked 8/8, 2013 at 17:14
2
Solved
In short: I want to do an XML Bulk Load to a SQL Server (2008) database and generate auto-increment-id's for a parent, that can be used in the child. This seems limited by the scope: the parent-nod...
Valuator asked 15/11, 2012 at 12:52
2
Solved
Given table T with columns:
ID UNIQUEIDENTIFIER
CreatedDate DATETIME
XmlData XML
Where XmlData is structured like:
<application>
<details firstname="first" lastname="last">
<st...
Osrick asked 2/10, 2012 at 12:55
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
2
Solved
How to change my query so that this error doesn't happen:
XML data type method “value” must be a string literal
T-SQL code:
Declare @Count Int = 1
While(@count <= @j)
Begin
insert...
2
Solved
I'm using SQL Server 2008's XML-parsing abilities to iterate through an XML document and perform an INSERT each element.
However, my stored procedure appears to be inserting each element into the ...
Hopehopeful asked 3/4, 2012 at 16:30
1
Solved
I'm trying to generate an XML output from SQL and need to use a UNION statement and also name the output column.
I had this working before when I didn't need to use a UNION statement using:
selec...
Bereave asked 16/2, 2012 at 12:22
2
Solved
I'm using a generic system for reporting which takes data from a database view (SQL Server 2005). In this view I had to merge data from one-to-many relations in one row and used the solution descri...
Elitism asked 8/7, 2010 at 9:53
3
Solved
I am working with SqlXml and the stored procedure that returns a xml rather than raw data. How does one actually read the data when returned is a xml and does not know about the column names. I use...
Switchback asked 20/10, 2011 at 5:34
1 Next >
© 2022 - 2024 — McMap. All rights reserved.