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 7 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
Leave a Comment

(required) 

(required) 

(optional)

(required)