本文发表在 rolia.net 枫下论坛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
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