XML file to SQL Server table - best way?
Fri, 7 Mar 2008 07:06:00 -0800
Background:
We have some systems that perform tests on piece-parts and modules to see if
they work and meet spec. The testers (boxes not people) record data during
the testing process and dump that data into an XML file stored local to the
tester.
We'd like to get the results out of the XML file and get t ...
|
Silent performance killer with promoted column
Thu, 6 Mar 2008 09:02:41 -0000
Half open question, half dire warning ;-p
[I'm kinda hoping Mr. Rys might perhaps spot this one?]
I got stung yesterday by a curious performance issue on 2005 (I haven't
tried it on 2008) - basically, it involves a promoted, persisted and indexed
field from an xml column. When the SET statements are all co ...
|
SQL 2005 For Xml Path question
Tue, 4 Mar 2008 11:09:04 -0800
In the SQL 2005 Books Online section titled "Using PATH Mode", there is an
example near the bottom that results in the following XML. Is there a way to
get the xml so it's encoded correctly (not using < >)? Not sure why it's
doing this since I have a query that returns the same thing.
<ProductModelData PI ...
|
[announce] Free XQuery Training Event
Mon, 3 Mar 2008 08:20:07 -0800 (PST)
Dear microsoft.public.sqlserver.xml,
DataDirect Technologies is hosting a free XQuery tutorial workshop in
Chicago, Washington DC, Houston, as well as London and Amsterdam. The
XQuery covers the following topics:
* Transforming XML documents into user-defined formats
* Aggregating XML documents with relatio ...
|
insert xml file into remote SQL Server 2005?
Mon, 3 Mar 2008 00:30:13 +0000 (UTC)
I'm stumped as to how to insert data (shredded) from an XML file into a table's
columns. I tried using bcp but get "not trusted connection" error (its a
remote server so not using Windows Authentication). I don't think I can use
bulk load with OPENROWSET because the datafile isn't on the server.
Any suggest ...
|
XQUERY big problem
Fri, 29 Feb 2008 12:25:43 +0100
Hello
I try import data from XML file to MSSQL2005 using XQUERY
xml like:
<start>
<section>
<data1> </data1>
<data2> </data2>
<data3> </data3>
<person> P1 </person>
<person> P2 </person>
<car>
<car_name>CC1 </car_name>
</car>
</section>
<section>
<data1> </d ...
|
3-way join -> xml tree
Thu, 28 Feb 2008 12:57:24 +0100
How do I join 3 tables to get the following xml structure:
<roottable>
<id>111</id>
<data>aaa</data>
<childtable1>
<id>222</id>
<data>bbb</data>
</childtable1>
<childtable1>
<id>333</id>
<data>ccc</data>
</childtable1>
<childtable2>
<id>444</id>
<data>ddd</data>
...
|
|
|
Query an xml column
Wed, 27 Feb 2008 18:19:19 -0800 (PST)
I am having trouble querying a column in my sql server database that
contains the following xml
<BaseData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xsi:type="CarData"><RentalCars>123</RentalCars><LeaseCars>22</
LeaseCars><JunkCars>5</JunkCars></BaseData ...
|
configuring Report Server
Wed, 27 Feb 2008 06:37:56 GMT
I just installed SQL Server 2005 Express Advanced, which has reporting
services. IIS is installed. I'm configuring the Report Manager Virtual
Directory Settings part of the "Configure Report Server". This is a 2 part
question:
1. After configuring the Report Manager Virtual Directory, the icon remains
...
|
Extract Attribute across many XML docs
Tue, 26 Feb 2008 10:33:01 -0800
I want to extract the value of the CorrelationID without having to specify
the entire path. There will be over 50 different XML documents with
this attribute and I would like to avoid a large number of statements to get
this value.
declare @MessageBody xml
,@CorrelationID bigint
select @Mes ...
|
