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

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

因为公司使用WCF开发系统，要做两次转换，所以写了这个通用的转换代码，反射写的，性能较差，有待改进。

比如有个实体类ItemEntity，有个接口类ItemData，完成转换只需如下

ItemData data = CommonTransfer.ToTarget<ItemData,ItemEntity>(entity);

即可，要提供性能可以使用Emit自己写IL代码，这个太复杂不想研究了，还有个方法就是使用.NET 3.5的新特性，表达式树。有时间研究下 阅读全文>>

Here are the WinDbg / SOS commands I talked about at Code Camp NY.  These are the basic commands to get you going with WinDbg / SOS.

Starting, Attaching, Executing and Exiting

阅读全文>>