Extract element name and attribute name-values from XML
Thu, 5 Jun 2008 09:46:47 -0700 (PDT)
In SQL Server 2005, if I have an XML variable that I know contains a
single element, but I don't know what the element's name is, or the
names of its attributes or how many attributes it has, how can I
extract (1) the name of the element as a varchar, and (2) the names
and values of its attributes as a two colum ...
|
Trigger won't fire using SQLXML 3.0
Tue, 3 Jun 2008 11:37:01 -0700
I'm using SQLXML 3.0 with VB.net to upload xml files to SQL Express. One XML
uploads to multiple SQL tables. One table has a trigger to update fields in
one of the other tables.
Unfortunately, the trigger won't fire. The trigger will fire with a simple
T-SQL INSERT script but won't using SQLXML.
[code]
AL ...
|
Saving Mal-formed XML
Tue, 3 Jun 2008 10:46:38 -0400
I am converting thousands of XML files to a SQL Server 2005 Database.
Everything goes fine, until I run into a section of mal-formed XML. In
passing the XML section to the stored procedure for inserting it into the
Section table, I receive the following error: "XML parsing: line 1,
character 1061, undeclare ...
|
Implementing IODEF XML Schema in SQL 2005
Fri, 30 May 2008 11:47:02 -0700 (PDT)
Hi folks,
I'm new to XML and need to implement the IODEF XML Schema (http://
staff.science.uva.nl/~demch/projects/iodef/index.html) in SQL 2005.
I downloaded the latest schema (http://staff.science.uva.nl/~demch/
projects/iodef/draft-ietf-inch-iodef-044.xsd) and attempted to load
this XSD file using the tip ...
|
Best practise for storing HTML within a single XML field
Thu, 29 May 2008 06:05:01 -0700
I would like to write a rich text messaging system. Basically, I have a
WYSIWYG textbox component that allows users to format a message with HTML.
The problem is how do I store this data?
Ideally I would like to have a single SQL2005 XML field that holds all of
the userâ??s messages. I could then simply dat ...
|
bypass CDATA transformation
Wed, 28 May 2008 16:04:31 +0200
Hi,
You know that when you INSERT or UPDATE in a XML type field of table, SQL
Server deletes the CDATA et encode the section with HTML characters.
exemple :
CREATE TABLE #test ( xmldata xml )
INSERT INTO #test VALUES ('<test><![CDATA[test with & < >]]></test>')
SELECT xmldata FROM #test
It displays : ...
|
remote SP to shred local XML file
Tue, 27 May 2008 15:30:33 -0700 (PDT)
SQL Server 2005
I have an XML file and I'm using a stored procedure to shred it into
tables. Works perfectly so long as the file is on the server.
What I want to do is have an Excel file with VBA call the procedure on
a remote SQL Server, and have the procedure read the XML file that is
stored locally. Wh ...
|
|
|
Querying/Updating XML in SQL 2005
Tue, 27 May 2008 11:47:52 -0700 (PDT)
Sorry if this posted twice, I think I hit the post message too early.
Here is my complete post:
I have the following XML store in an XML column in a SQL 2005
database.
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://
schemas ...
|
How to retreive parent nodes and values from a child node?
Fri, 23 May 2008 10:49:01 -0700
Hello,
I have an XML as below.
declare @doc2 xml
SET @doc2 = '<?xml version="1.0" ?>
<p1:Domains_and_Emails xmlns:p1="LDAP">
<Organization>ABCD</Organization>
<Radius Suspended="false" ID="1" Platform_Id="7"
ObjectClass="radiusprofile">
<Common_Name>OptiUser</Common_Name>
<radiusProfileDn>cn ...
|
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 ...
|
