Dimension limit of an XML document for SQLXML BulkLoad
Mon, 19 May 2008 04:08:00 -0700
What is the size limit of an XML document to import by SQLXML BulkLoad 3.0
for SQL Server 2000?
Thanks ...
|
Use named ROOT for import XML document
Sun, 18 May 2008 10:49:00 -0700
I want to import an XML document by SQLXML BulkLoad with the root element not
named <ROOT> ... </ROOT>, but having a specified meaningful name.
What do I write in the related XSD schema in order to does SQLXML BulkLoad
function correctly?
Thanks ...
|
How to get XML from an ADO recordset
Sat, 17 May 2008 17:34:45 -0700
I would like to pass the contents of a temporary table in Access to a SQL
Server stored procedure string parameter via XML.
Is it possible to get the contents of an ADO recordset returned as XML
without first persisting it to file? I don't have the luxury of working with
ADO.NET.
Patrick
=-=-=-=-=-=-=-= ...
|
Implicit setting of an identity field with SQL XML BulkLoad
Sat, 17 May 2008 15:48:00 -0700
I'm using SQLXML 3.0.
I want to import a XML document in a SQL table that has an identity field to
value automatically.
The XML document specifies two attributes and the table has the two
corresponding fields adding the identity field.
I don't want to explicit a value for the identity field in the file XML.
...
|
SQLXMLBulkLoad with ODBC
Sat, 17 May 2008 15:16:01 -0700
I have installed SQLXML 3.0 to use the SQLXMLBulkLoad functionality inside a
VBScript code.
Now, is it possible to specify in the connection string the data related an
ODBC or do I must use only the OLE DB provider for SQL Server?
Thanks ...
|
ancestor syntax
Fri, 16 May 2008 12:27:58 -0700
Hi,
does MSSQL Server support the XQuery Syntax ancestor?
...
|
About installing SQLXML 3.0 for SQL Server 2000
Fri, 16 May 2008 05:46:00 -0700
I have downloaded SQLXML 3.0 to use the XML Bulk Load functionality.
I have a client application that connect to a SQL Server 2000 on a server
machine.
Where do I install it? Only onto the client?
Thanks ...
|
|
|
Importing a txt file with XML content
Wed, 14 May 2008 09:48:01 -0700
I'm using SQL Server 2000.
I need to save the XML content contained into a txt file in a image SQL
server field and then convert this field in a text/char field before using
the OPENXML statement.
Do I have to use READTEXT? How can I know the total size of the data stored
in the image field?
Thanks ...
|
Identifying the nodes using OPENXML
Wed, 14 May 2008 01:51:01 -0700
I'm using SQL Server 2000.
I must import a document structured in XML.
This document has a root, some invoice header nodes and inside a single
invoice header some invoice details are present.
The invoices data are written as attributes.
When I insert the data from the XML document in a specified table I want t ...
|
finding nodes in xml files
Tue, 13 May 2008 10:52:01 -0700
I have xml feed files that we investigate for bugs. The size of these files
is quite big (ranging from 500 KB to 1.4 GB).
My aim is to search these files for some specific string value in some
element text or attribute text and display all resulting nodes as xml for
debugging.
What is the best method to ...
|
