Using WITH XMLNAMESPACES in a function
Fri, 23 May 2008 02:50:11 -0700 (PDT)
Dear SQL Server XML experts,
I have a problem with using the WITH XMLNAMESPACES clause within a
function. This function shall return an XML fragment that will later
be used in a SELECT statement. I need to add a default namespace to
the XML document.
My code looks like the following:
CREATE FUNCTION data ...
|
xml update
Wed, 21 May 2008 08:35:01 -0700
I have id and xml columns in mytable. I want to update an element called
myelement with the following
UPDATE MyTable SET
xml.modify
('replace value of
(/root/child/grandchild/myelement)[1] with
xs:dateTime("2002-05-30T09:30:10Z")')
WHERE id = '00000000-0000-0000-0000-000000000000'
But I got
XQu ...
|
Retreiving Namespace URI
Wed, 21 May 2008 06:34:00 -0700
Hello,
I have a XML as below:
declare @doc2 xml
SET @doc2 = '<?xml version="1.0" ?>
<p1: Domains_and_Emails xmlns:p1="LDAP">
<Domain>
<UnixEmail>
<uid>info</uid>
<Password>xyz</Password>
<EmailAccount>info@xyz.com</EmailAccount>
</UnixEmail>
</Domain>
</p1: Domains_and_Emai ...
|
How to use a Variable in XQuery?
Wed, 21 May 2008 06:32:00 -0700
Hello,
I have a XML as below:
declare @doc2 xml
SET @doc2 = '<?xml version="1.0" ?>
<p1: Domains_and_Emails xmlns:p1="LDAP">
<Domain>
<UnixEmail>
<uid>info</uid>
<Password>xyz</Password>
<EmailAccount>info@xyz.com</EmailAccount>
</UnixEmail>
</Domain>
</p1: Domains_and_Emai ...
|
XQuery and Datetime
Wed, 21 May 2008 11:44:23 +0200
Hello,
how do I insert a datetime value in an xml variable ?
«insert element Value {sql:variable("@Value")}»
fails because DateTime is not supported in XQuery.
Thanks for your help.
--
Fred
foleide@free.fr
...
|
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 ...
|
