posted on Wednesday, February 25, 2004 9:56 AM
by
demiliani
Importing Hierarchical XML into SQL Server 2000
I want to signal an interesting post on Tim Walters blog: Hierarchical XML - importing into SQL Server 2000.
Tim show us 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.
Interesting!