muebermuth
Technical User
multiple xml data readout of whole xml file to one sql 2000 table, each row must have its own id.
Problem 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?
Martin Uebermuth
Aachen
Germany
Problem 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?
Martin Uebermuth
Aachen
Germany