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.

Posted: Feb 25 2004, 03:50 PM by XMLEvangelist | with 9 comment(s)
Filed under:

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

Rufus said:

Yeah Tim... don't be a meanie monster. Sally-Anne is right.

# August 13, 2009 10:16 PM

Herve Leger sales said:

Which means you can simply attain any cross-product is extremely simple, but whereas using the proposed compromise on style.unt Couturier Azria also specific nature.

# September 15, 2011 8:57 PM

Red Bull Hats said:

I am looking forward to reading more of your posts in the future.I am Happy to be here! Interested parties can contact a lot

Perhaps this is one of the most interesting blogs that I have ever seen. Interesting article, Funny comment. Keep it up!

# October 28, 2011 11:21 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)