Stangray
SAP THQ Apple Nintendo Google Reynolds Amazon Yahoo
11 2010 档案
在没有主键的情况下定量删除数据!
摘要:整行语句:select * from dbo.FreightRate where enabled=0 and createddate < (select max(createddate) as mx from (select top 100 createddate from dbo.FreightRate where order by createddate)a)分解说明:--按时间取前10... 阅读全文
posted @ 2010-11-12 10:15 Stangray 阅读(313) 评论(0) 推荐(0)