<root>
<custom_id>-1</custom_id>
<country_id>24</country_id>
<channel_id>1</channel_id>
<currency_id>2</currency_id>
<weight1>1</weight1>
<weight2>1</weight2>
<basicweight>1</basicweight>
<price1>1</price1>
<price2>1</price2>
<minusweight>1</minusweight>
<isdelete>0</isdelete>
<iscubage>1</iscubage>
<cubage1>2</cubage1>
<cubage2>2</cubage2>
<createdate>2012/2/23 13:16:42</createdate>
<surcharge_list>
<surcharge>
<cost_id>0</cost_id><price>1</price><relation>0</relation><ordernum>1</ordernum>
</surcharge>
<surcharge>
<cost_id>0</cost_id><price>2</price><relation>0</relation><ordernum>2</ordernum>
</surcharge>
<surcharge><cost_id>0</cost_id><price>3</price><relation>0</relation><ordernum>3</ordernum>
</surcharge>
</surcharge_list></root>

declare @idoc int
declare @idos int
declare @doc xml
set @doc='<root><surcharge_list><surcharge><cost_id>0</cost_id><price>1</price><relation>0</relation><ordernum>1</ordernum></surcharge><surcharge><cost_id>0</cost_id><price>2</price><relation>0</relation><ordernum>2</ordernum></surcharge><surcharge><cost_id>0</cost_id><price>3</price><relation>0</relation><ordernum>3</ordernum></surcharge></surcharge_list></root>'

exec sp_xml_preparedocument @idoc output,@doc

select * from
OPENXML(@idoc,'/root',2)
with(custom_id int,country_id int,channel_id int,currency_id int ,weight1 decimal ,weight2 decimal,basicweight decimal,price1 decimal,price2 decimal,minusweight decimal,isdelete bit,iscubage bit,cubage1 decimal,cubage2 decimal ,createdate datetime)
select @idos=@@IDENTITY

insert Surcharge(cost_id,price,relation,ordernum)
select * from
OPENXML(@idoc,'/root/surcharge_list/surcharge',2)
with(cost_id int,price decimal,relation int,ordernum int)

exec sp_xml_removedocument @idoc

------解决方案--------------------
楼主此处为何需要使用modify()函数?