in

ASP.NET Weblogs

Tim Walters .NET Blog

Microsoft .NET, along with XML, XSL, XSD, SQL and other cool stuff

Hierarchical XML - importing into SQL Server 2000

I've just finished my first draft of a new article on how to import infinite-depth XML trees into a parent/child table in SQL Server 2000.

It uses table variables and OPENXML to do most of the tricks, along with an interesting WHILE loop.

Have a read and see what you think, I'd love to hear your feedback.

Comments

 

TrackBack said:

Importing Hierarchical XML into SQL Server 2000
February 24, 2004 12:56 PM
 

TrackBack said:

February 25, 2004 4:41 PM
 

TrackBack said:

January 3, 2005 1:44 PM
 

TrackBack said:

^_^,Pretty Good!
April 9, 2005 4:15 PM
 

Raj said:

How to insert xml file into sql server

November 28, 2007 5:36 AM
 

Sally-Anne Westendorf said:

Hi Tim, remember me? Your sister?  How's Michelle & the twins?  Try contacting me once in a while... other than 10mins before you're due at the airport to leave Brisbane...

July 26, 2008 11:00 AM

Leave a Comment

(required)  
(optional)
(required)  
Add