Declare @Count int
SET @Count = 0
WHILE(@Count < 21)
BEGIN
SET @Count = @Count + 1
Update dbo.DataFeedItemDetailSSB_Record
SET message_body.modify
('declare default element namespace "http://soa.newegg.com/SOA/USA/InfrastructureService/V10/PubSubService";
replace value of
(/Publish/Node/DataFeedItemDetailV10/Body/ItemDetailInfoList[1]/ItemDetailInformation[sql:variable("@Count")]/ItemBasicInformation/UPCCode/text())[1]
with
sql:column("DataFeedItemDetailSSB_Record.RowID")*100 + sql:variable("@Count"),
')
WHERE Rowid <= 20
Update dbo.DataFeedItemDetailSSB_Record
SET message_body.modify
('declare default element namespace "http://soa.newegg.com/SOA/USA/InfrastructureService/V10/PubSubService";
replace value of
(/Publish/Node/DataFeedItemDetailV10/Body/ItemDetailInfoList[1]/ItemDetailInformation[sql:variable("@Count")]/ItemStaticInformation/OwnerSKUNumber/text())[1]
with
sql:column("DataFeedItemDetailSSB_Record.RowID")*100 + sql:variable("@Count")
')
WHERE Rowid <= 20
END
更新DataFeedItemDetailSSB_Record表中xml字段中的UPCCode和OwnerSKUNumber，其中UPCCode在一个List中。
