Want to import xml File to sql server 2000.

fxue (fxue)
本文发表在 rolia.net/zh 相约加拿大网上社区枫下论坛
Want to import xml File to sql server 2000.
as to say build out of xml file (9 hirachical levels) an SQL server
2000 table with 9 columns representing the 9 hirachical levels
represented
in xml file)

Problem at the moment xml-file can be only 8000 varchars long with
sp_prepare:document
But my xml-file is 20000 varcahrs long.
how can i put the info from xml-file in one table in sql server 2000
with hirachie levels from left to rigth in table.
I have 9 hirachie levels in my xml file.
Is it possible to open sql 2000 tables and datatbases on SQL 7.0?
Hope you can help me or show me way to transform and read data from
xml file out into sql table automatically.
just trying in SQL query analyzer.
but little effort till now.
limit 8000 varchars
alternartives?

create a table in sql server 2000 with 9 clumns and neatrly
unlimmited amount of rows? (each row must have its own primary key!,
even if
something ist again loaded in the same table!)
Help please! Thx!
更多精彩文章及讨论,请光临枫下论坛. 网址: rolia.net/zh
(#235583@0)
2001-10-24 -05:00

回到话题: Want to import xml File to sql server 2000.

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论

URL:   
http://www.rolia.net/zh/post.php?f=0&p=235583