SQL Server XML

Im using Sqlxml 30 with sql 2000 and Visual studio 2003. if I generate my xmldata file  manaually it works fine, However if i generate it using VisualStudio using dataset.writexml with ignoreSchema method i get an invalid xml ...

Hi How can I suppress field name from for-xml result? e.g., drop table t1 go create table t1 (i int) insert into t1 values(1) select * from t1 for xml raw(''), elements, root('a') may result in, <a><i>1</i></a> ...

Is there some way of storing XML in SQL Server 2005 as "pure" XML as, say, an XML order per record (unshredded to extract the original data ) and then querying the XML to get aggregate information on individual orders (e.g. sum of cost of all items in order) and then further ...

The easiest way to illustrate my problem is to run the following SQL on SQL 2000, then on SQL 2005 to see the difference. Don't try to make sense of what I'm doing with the data in this particular illustration because it ...

I am trying to insert a row from an XML document into a table. Here is the table structure: CREATE TABLE dbo.Customer( CustomerGUID uniqueidentifier NOT NULL, CustomerName varchar(25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, Version int NULL, ActivatedDate smalldatetime NULL, ActivatedByWS uniqueidentifier NULL, ...

Hi, How are transactions managed when publishing stored procedures as web services? Does SQLXML automatically commit the transaction if the stored procedure succeeded and rollback if it failed? Thanks. ...

Hi All, First, the term explanation, so you know what I am talking about: 1. HL7 - file that contains patient information; tab delimited. 2. CloverLeaf - interface engine that translates HL7 files into different formats. For those of you who have some experience in single- and multi- threading ...