I think there should be no problem doing this....

Hi

I do not think it is a good idea to run a DTS package continuously. Probably you should look for REPLICATION options. I never got a chance to work...

I have not done a "MAXIMUM" test yet. I do not recommend this as an option for BULK INSERT/UPDATE operation. There are other utilities for that. This approach might be...

I dont think this approach is good for Large Chunks of data. It is handy when you have a small piece of delimited string and you want to break it...

I understand the problem now. A schema will validate an entire document. I do not think that a schema can be used to filter "bad records" and process the...

I agree with you on the first point. Wherever I used the XML approach in our applications, it just worked well. However, I have read some posts where people complained...

KB is right. The function ROW_NUMBER() itself is specific to SQL Server 2005. SQL Server 2000 does not support this.

Ryan Riley (11/7/2007)

---

Great article, Jacob. I think you might have mentioned this previously, but is there a limit to the number of characters an XML query will return? Also, is...

Excellent!

Ryan's code is much simpler than the two options I presented. This is really good and easy to understand.

one small note: we need to make sure that the OrderHeader will...

flurk118 (10/25/2007)

---

Nice article.

Has anyone got any examples of similar XML output but with header information included.

Following on from Jacobs article and presuming the existence of an OrderHeader table, the output...

Very interesting stuff, and I am glad that I found it right at the moment when we were thinking about partitioning a couple of our databases. Waiting for the next...

 

Hi Carlos,

You can do this in SQL Server 2000 too....

Ryan,

run this query:

(excuse the bad formatting)

 

WITH

XMLNAMESPACES (

DEFAULT 'http://www.namespace.net/yourschema.xsd'

)

SELECT