Developer Newsgroups: SQL Server XML

Can I validate this xml somehow?

Jeremy Chapman - 11 Dec 2004 12:35 AM - 3 messages

I have a stored procedure which takes a varchar. the contents of the varchar *Should* be a valid xml and should represent a pre-defined schema. How can I validate that the xml is a valid schema? I need to ensure that the root node is <s>, that it can have many <p> nodes ...

Help to export in XML with Explicit option

not4u - 10 Dec 2004 9:44 AM - 4 messages

XML Tag Parse / Reader Fun!

BillB - 9 Dec 2004 4:07 AM - 2 messages

Hi all, I searched 24 plus hours and came up with nothing for a stored procedure that would read and strip an XML doc into text. This is a pretty good representation of a stored proc to parse xml tags... Hope someone else can ...

Can OPENXML insert rows with some duplicate rows?

Thana N. - 8 Dec 2004 1:03 PM - 4 messages

Hi All, I'd like to insert rows that maybe have some duplicate rows with OPENXML from stored procedure. In normal case, I've found that it cannot do that. Is there anybody know how to accomplish this? ...

SQL database from XMl,XSD files

Don Baechtel - 8 Dec 2004 12:57 PM - 3 messages

How do you create a SQL database from XML/XSD files? ...

Trouble Installing SQLXML 3.0 SP3

Larry Bird - 7 Dec 2004 9:45 PM - 2 messages

I'm trying to install SQLXML 3.0 SP 3 on a Windows XP Pro SP2 machine. When I run the "MSI" file I get the following message: "SQLXML 3.0 SP 3 setup ended prematurely becuase of an error. Your system ...

xmlns attribute in root element

Jeff Langston - 7 Dec 2004 5:26 PM - 4 messages

I have a xml file where the root element has xmlns attribute. When I try and import it using a xsd file and sqlxml bulk insert it does not insert any records. When I remove the xmlns attribute it works perfectly. How can I ...

xml bulk import - PLEASE HELP!!!

Jeff Langston - 7 Dec 2004 3:04 PM - 2 messages

Below is my vbs script, table, schema, and xml data. When I run the vb script I don't get any errors OR records. I used VS.Net to create the schema and I added the sql relation attribute to it. I thought that was enough, but ...

Designing "XML Proof" databases?

Brian Madden - 7 Dec 2004 12:58 PM - 2 messages

Hello All, I'm fairly new to the XML game. I am designing a database that will contain online books. Each book will be broken into parts, each part into chapters, each chapter into sections, each section into... you get the idea. I think ...

Returning prepared query from SQLXML template

Andrew Hilton - 6 Dec 2004 11:39 PM - 2 messages

If you have an SQLXML template, with some parameters, is there any way to return the prepared query (parameters substituted with values passed in) without XML4SQL executing the query? For example, take the following template: <ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql"> ...

Re: help with OPENXML

Michael Rys [MSFT] - 6 Dec 2004 11:31 PM - 1 message

Hi Bernard What are the schemas of your relational tables? Since you get the rows, your path expressions find the nodes that map to rows, but it looks like that the relative paths implied by the relational schema does not find any values for the nodes where you get NULL. ...

Re: SqlXml 3.0 Sp3 Available Now!

Irwin Dolobowsky [MSFT] - 6 Dec 2004 7:58 PM - 1 message

You do need to uninstall any previous copies of SqlXml before installing this one, yes. Download the SP, have it ready, uninstall the old one, install the new one. Whole process shoudl only take a couple of minutes and ...

Re: SQLXMLBULKLoader Question

Irwin Dolobowsky [MSFT] - 6 Dec 2004 7:50 PM - 1 message

Unfortunatly no. Bulkload can automatically pull values from Identity columns, but that's it. ...

xsd annotations for xpath query

Martin - 6 Dec 2004 5:30 PM - 4 messages

Hi, I want to query my database to get an xml doc similar to this: <node NodeId="1" xmlns="http://tempuri.org/TreeNode2.xsd"> <node NodeId="2"> <node NodeId="3"></node> ...

XML to Excel

Marwa Bahaa - 5 Dec 2004 3:29 PM - 2 messages

HI all, I have an application using ASP.net, and in this application the user will have the choice to download data from Sql Server to excel sheet,this will be done using code only could any one help me how to do this plzzzz??? ...

XQuery with SAXON.NET

exemell.com user - 5 Dec 2004 1:05 PM - 2 messages

Does anyone know of any good resources with examples showing how to implement SAXON.NET's XQuery? Thanks Wole Posted at [link] ...

XML Error.

Reddi - 5 Dec 2004 5:29 AM - 2 messages

Hi, Windows 2003 EE, SQL Server 2000 EE with A/A configuration on Cluster. The server was dead slow during DML operations & Received series of the bellow error. After a hour or two the server acted normally. I also observe ...