Ning's Blog

阅读全文>>

博客好久没有弄了，测试一下，明天开始写一些学习日记。

declare @Reqeustid int
set @Requestid = 1500
while(@Requestid < 3000)
begin
delete from ItemRequestImage where  TransactionNumber  in
(select top 2 TransactionNumber from ItemRequestImage where requestid = @Requestid)
and requestid = @Requestid
set @Requestid = @Requestid + 1
end

对1500条数据循环Delete top.

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中。

白社会是搜狐的SNS，刚刚推出，正在测试，很好玩。

目前，只有邀请才能注册，链接地址如下：

http://bai.sohu.com/user/reg/invite.do?u=144504&type=0&t=1244742447837&s=05528eca7da9b299fa856acbcb4a0291

阳光牧场，真心话，说秘密，很好玩！