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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-23 : 09:23:09
|
Brad writes "Hey guys I have been looking all over for a direct answer to this question and no one will give it. How can I populate a SQL database table with XML information. The XML is as follow and is update from a server everyt 15s or so. I will just be over-writing the information in the table every time:<chain name="0#3C:" data_quality="Delayed"><ric name="3CX1"> <fid id="DSPLY_NAME">CORN Nov1</fid> <fid id="TRDPRC_1">206 2/8</fid> <fid id="NETCHNG_1">0 4/8</fid> <fid id="BID">0.00</fid> <fid id="ASK">0.00</fid> <fid id="HST_CLOSE">205 6/8</fid> <fid id="ACVOL_1">0</fid> <fid id="EXPIR_DATE">14 NOV 2001</fid> <fid id="TRDTIM_1">11:31 EST</fid> <fid id="TRADE_DATE">02 OCT 2001</fid></ric> I am then going to use SQL/XSLT to output a XHTML file. I know how to do that, it's just I can't find a straight answer on how to populate and edit. Please help.p.s. I am getting the XML from an outside server,throught a proxy, using ASPHTTP. (using SQL 2000 on Win 2K, IE 5.0 display)TIA Brad" |
|
|
|
|
|
XML input