Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slimt_slimt
Aged Yak Warrior
746 Posts |
 Posted - 2009-08-05 : 14:36:23
|
hi,i'm having sql server 2000 (unfortunatelly) and what i would like is to read a piece of information from xml file.sql 2005|2008 can do this with bulk insert and openrowset, SELECT * FROM OPENROWSET ( BULK 'C:\TEST.XML',SINGLE_CLOB) AS A but obviously it's not that straightforward in sql 2000.got any ideas? samples?thank you in advance |
|
|
|
|
|
read xml file with t-sql