Tagged Questions
13
votes
2answers
536 views
Optimising plans with XML readers
Executing the query from here to pull the deadlock events out of the default extended events session
SELECT CAST (
REPLACE (
REPLACE (
XEventData.XEvent.value ...
5
votes
1answer
175 views
SQL Server / MySQL to DTD (+XML)
Is there any way I can at least export a table schema from MSSQL or MySQL to a DTD file? Also the same for the data of the tables to XML.
I am really not getting how to write DTDs, so I badly need a ...
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?
4
votes
1answer
54 views
How to shred .docx XML?
I am trying to import a xml (actually a docx file) to a sql server 2008 database. I am almost a novice in XML programming. I googled a lot but almost all the examples there are with simple xml file. ...
4
votes
1answer
613 views
T-SQL: Convert XML to string without self-closing tags
We have a weirdo system we're integrating with which consumes XML, but it does not understand self-closing tags, so
<BOOKING>
<BOOKINGID>56812</BOOKINGID>
<PERSONCODE />
...
3
votes
1answer
72 views
Item Index for all items in nested XML query
I have a requirement to build an XML package with a parent record, and 1..N related child records.
The child records are to be a nodes under the parent node, and there may be one child record or ...
2
votes
2answers
452 views
Fast XML, slow XML
Our database update Windows application needs to transfer some data between two databases as part of the process for a certain one-time update. I chose XML as the intermediary to move the data.
The ...
2
votes
1answer
57 views
Would appreciate some advice on using external data with SQL Server 2005
I'm a web developer with a bit of DB experience, but this one is beyond my knowledge.
We're trying to set up a new website. The data - products, prices, descriptions etc - are supplied by an external ...
2
votes
1answer
38 views
FOR XML is generating a empty first line
I'm parsing with flash a XML file generated by this code:
:XML ON
USE MyDatabaseName
GO
SET NOCOUNT ON
SELECT * FROM ProgramacionDia as programa order by hora
FOR XML AUTO,
ROOT ('toflash'),
...
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
177 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,
...
2
votes
1answer
81 views
I would like to better understand the SQL Server security model in terms of users and groups to possibly replace an XML heirarchy model I am using
I am currently using XML in my database to represent metadata for individual products. I am using the below schema to enter the data. In each sub grouping of fields you will notice the cms_name ...
2
votes
1answer
313 views
How do I merge two XML variables in SQL Server (2005/2008)?
Forward: I've already read this StackOverflow thread and it does not address the depth retention I need.
I want to create an XML document that contains the data definition objects for a single ...
2
votes
0answers
157 views
going from heirarchical XML to heirarchical SQL tables then SQL to c# objects to go to user view, how should I store the data in the databases?
Hi I'm getting my data from a web service using their getData call and it comes in as fairly chunky heirarchical XML, first everything all at once, like
<allData>
<product1>
...
1
vote
3answers
127 views
SQL Server xml performance
I have a table with 21 columns. The majority are numerical and the rest are nvarchar.
I need to add 4 columns that will contain XML data for each row. The XML data for each row can be anywhere from ...
