Tagged Questions
0
votes
3answers
74 views
SQL agent job step's connection managers
Is there any way with T-SQL to list the connection managers that are used in an SQL Agent Job step?
6
votes
1answer
139 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. ...
0
votes
0answers
102 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
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, ...
2
votes
1answer
42 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'),
...
3
votes
1answer
76 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 ...
1
vote
1answer
239 views
SSMS Oracle import using OpenQuery over LinkedServer (Oracle Provider for OLEDB) - XML Parsing: unable to switch encoding
I am trying to migrate the data from an OracleDB to an SQL Server Express database. I'm doing this by openquerying a linked server (data provider based on Oracle Provider for OLEDB). Everything works ...
1
vote
3answers
134 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 ...
13
votes
2answers
568 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 ...
1
vote
2answers
142 views
XML Large DataBase is the best? [closed]
Is the best way to implement a large database is XML? Or is there a better way?
1 - reduce the time complexity
2 - Reduce the amount of traffic between the tables
And other factors ...
Which ...
0
votes
1answer
112 views
avoid insert xml duplicate data
how can to prevent duplicate inserts for every Execute?
insert into IQ (XMLDT)values('<row>sdsdf</row>')
2
votes
1answer
259 views
how to convert xml to database table
input:
Declare @OUT xml
select @OUT = N'
<row>
<kind>MainCat</kind>
<sortid>1</sortid>
<kind_id>1</kind_id>
<PPoet>حافظ</PPoet>
...
5
votes
1answer
181 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 ...
2
votes
2answers
476 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
83 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 ...
4
votes
1answer
630 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
327 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 ...
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 ...
2
votes
0answers
158 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
1answer
394 views
SQL Database to XML?
I would like to export SQL data to an XML file so it can be read in COBOL. I am working with SQL Express 2008 r2.
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
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,
...
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 ...
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?
