XML performance extremely slow for no obvious reason
Sat, 03 Mar 2007 22:27:31 +0000
Hi.
I'm using SQL 2005 (SP1 and SP2, doesn't make a difference) and am
seeing some very strange behaviour.
Here's a script to repro the issue:
------ BEGIN SCRIPT ------
if exists (select * from sys.objects where object_id =
object_id(N'[dbo].[data]') and type in (N'U'))
drop table data
go
creat ...
|
OASIS Symposium 2007 - eBusiness and Open Standards
1 Mar 2007 17:26:56 -0800
OASIS Symposium 2007. eBusiness and Open Standards: Understanding the
Facts, Fiction, and Future. Being held 15 - 20 April at the Marriott
Mission Valley, San Diego, CA.
$100 Discount expires March 19th!
This year's dynamic conference program and impressive list of speakers
are now confirmed. Visit http:/ ...
|
OpenXml sub elements
1 Mar 2007 06:53:56 -0800
Hi All,
I,m shredding this xml to view the data and ultimate goal is to insert
the data at a later stage but when I shred it with the syntax
mentioned below then I recieve only one record instead of 3 records
with different AnsOptions (last sub element).
Help!
DECLARE @doc xml
SET @doc =
'<DivisionNa ...
|
XML performance very slow
Wed, 28 Feb 2007 06:15:30 -0800
Hi
<SEC>
<CAM
Op="sdfdsf111"
Campo =
"
<Campo Campo="Hi" Tipo="String" Visible="1" HabilitadoFiltro="1"
FormaDespliegue="Caja" Habilitado="1" FunValidacion="spTIP_ValidaPrueba"
FunDespliegue="spTIP_DesplieguePrueba">
<Info>
<Caracteristicas>
<Caracteristica name="Orden" value=" ...
|
Cover up attempt
Wed, 28 Feb 2007 09:29:59 GMT
http://toiletseatcoverup.blogspot.com/ - Yahoo ads not performing well? Publisher profits in the toilet? Join the best affiliate program known to man.
Operation Release the hounds aka puppies.
Snooogy bear is no name for a pet cat.
...
|
Problem with bulk insert
27 Feb 2007 07:28:39 -0800
Hi all,
I am newbie in all the stuff about xml importing into sql server.
What I try to do is simple. It is take an xml file and drop it into a
table. I am using VS2005, SQLXML 4.0 and SQL Server 2000 (I think
there is no problem of compatibility)
When I run my program using the SQLXMLBulkLoad4Class cla ...
|
Changing output order for xml explicit
Mon, 26 Feb 2007 20:22:56 -0000
This one shouldn't be complicated or unusual but it's got me stumped!
Here's an example query.
select 1 as Tag,
0 as Parent,
us_id as [Person!1!Person!hide],
'' as [Address!2!Address1!element],
'' as [Address!2!Postcode!element],
us_telephone as [Person!1!Telephone!ele ...
|
|
|
how to avoid error for sql xml bulk load with nested complex type
Mon, 26 Feb 2007 11:46:08 -0800
I am using the SQL bulk load 4 but am new to xsd and sql schemas. Here is
my problem. I get a bulk load error stating I need a sql:relationship for
any of my nested complex types but the elements in my nested complex type is
not going to another table but to the same table as my first complex type.
H ...
|
Creating XML using For XML Explicit
26 Feb 2007 01:25:47 -0800
Hi,
I am stuck and I thought somebody can help me here. I am trying to
construct a query from a a table to create an XML result. My table has
the following columns
| Book | Author | Chapter | Page | URL | Description |
I am trying to get it to return
Any ideas on how to construct the query?
Thanks,
...
|
Opensource OpenXML Writer 1.2 released
25 Feb 2007 06:37:21 -0800
Feb 26, 2007 - OpenXML Writer 1.2, an opensource editor for generating
WordProcessingML .docx files, is ready for download. The generated
files can be opened and edited in Word 2007 and other softwares that
support the OpenXML format. This update adds support for bullets and
numbering, capability to read and ...
|
