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 25 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

web design london said:

very nice blog. looking forward to read  more from you. And want to know can we insert xml file into sql?

# February 15, 2012 4:21 AM

walk in shower said:

Thanks for the information.

# February 15, 2012 6:34 AM

Wet room said:

can we convert XML file into SQL?

# February 15, 2012 7:44 AM

Tiffany and Co Outlet said:

Very well worth appreciation of a blog, let a person get a lot of knowledge from high school, don't know from what when begin more and more like this web site, it always bring us more surprises more works.

# February 22, 2012 7:36 PM

LifeCell Reviews said:

I value the article post.Thanks Again. Want more.

# April 4, 2012 7:27 PM

Sellers said:

fxmHwK Really informative blog article.Much thanks again. Really Cool.

# April 5, 2012 4:21 PM

seo said:

Very neat blog article.Really looking forward to read more. Keep writing.

# May 8, 2012 12:17 AM

bookmarking said:

Y30Vpk A round of applause for your post.Much thanks again. Want more.

# May 10, 2012 9:28 PM

Cheap Seo Services said:

7KA4S6 Really informative blog.Thanks Again. Fantastic.

# July 9, 2012 5:55 AM

cheap bookmarking service said:

tvP9cn Thanks a lot for the blog. Great.

# September 21, 2012 7:37 AM

nike air max lebron 9 said:

War Horse director Steven Spielberg , who also attended, said it was a 'prestigious honour' to have the new royal couple as special guests at the premiere, which was held in London's Leicester Square in aid of The Foundation of Prince William and Prince Harry.

# September 24, 2012 8:30 PM

Jimmycn8hi said:

xoraz<a href=> tamba hali jersey </a>

lfzgo<a href=> dane sanzenbacher jersey </a>

mgpgr<a href=> plaxico burress jersey </a>

muosr<a href=> brandon jacobs jersey </a>

xdzsy<a href=> mario williams jersey </a>

# November 3, 2012 12:10 AM

zetagiefkmq@gmail.com said:

But lack of Microsoft support at the highest levels is retarding the RSS momentum. Neither you nor Bill has mentioned the technology in any public setting.

# December 13, 2012 7:45 AM

buy social bookmarks said:

15vZog I really liked your blog.Really looking forward to read more. Great.

# April 1, 2013 8:32 PM

Haskell said:

I seriously love your website.. Pleasant colors & theme.

Did you build this website yourself? Please reply back as

I'm wanting to create my very own blog and would like to learn where you got this from or what the theme is named. Appreciate it!

# April 15, 2013 12:50 AM

Lovett said:

My partner and I stumbled over here coming from a different

page and thought I might as well check things out. I like what I see so

now i am following you. Look forward to looking over your web page yet again.

# April 22, 2013 8:59 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)