SELECT C_NUMBER, O_GETNAME, O_GETTEL, O_GETADDRESS, O_NAME, O_TEL, O_ADDRESS,O_DATE, O_TOLTOLPRICE FROM OpenXML(@idoc, '/Orders') WITH Orders 我想问一下with后面的字段是指xml的还是数据库里面的表里面的字段的
you should get some errors since some those quotes are invalid, try <Orders C_NUMBER="ocean" O_GETNAME="杨耀平" O_GETTEL="3297277" O_GETADDRESS="16-211" O_NAME="杨耀平" O_TEL="3297277" O_ADDRESS="16-211" O_DATE="1/1/2001" O_TOLTOLPRICE="2000"> <LineItem P_NUMBER="chaxiao" AMOUNT="4" P_SELL="60.00" /> <LineItem P_NUMBER="cup" AMOUNT="5" P_SELL="20.00" /> <LineItem P_NUMBER="jiaxing" AMOUNT="2" P_SELL="30.00" /> </Orders>
"with" can take either SchemaDeclaration or TableName
O_ADDRESS,O_DATE, O_TOLTOLPRICE
FROM OpenXML(@idoc, '/Orders')
WITH Orders
我想问一下with后面的字段是指xml的还是数据库里面的表里面的字段的
<Orders
C_NUMBER="ocean" O_GETNAME="杨耀平" O_GETTEL="3297277" O_GETADDRESS="16-211" O_NAME="杨耀平" O_TEL="3297277"
O_ADDRESS="16-211" O_DATE="1/1/2001" O_TOLTOLPRICE="2000">
<LineItem P_NUMBER="chaxiao" AMOUNT="4" P_SELL="60.00" />
<LineItem P_NUMBER="cup" AMOUNT="5" P_SELL="20.00" />
<LineItem P_NUMBER="jiaxing" AMOUNT="2" P_SELL="30.00" />
</Orders>
具体问题还需具体分析。我们用QQ详细谈谈吧