摘要: T-SQL语句:select * from (select row_number() over(order by id) as idx, T_A.* from T_A) as T_B where T_B.idx between (PageNum-1)*PageCount and (PageNum-1)*PageCounteg:select * from (select ROW_NUMBER() over(order by ID) as idx,dbo.客户.* from dbo.客户) as b where b.idx between 1*10 and 2*10 阅读全文
posted @ 2010-12-31 11:42 cosa7 阅读(326) 评论(0) 推荐(0)
摘要: This evening , after reading some articles in cnblogs.com ,I delete all the atricles in my blog , nethier creatted by others nor written by myself. because many of them were not realliy written by myself , so from now on, I will try my best to writte something myself. and this is the first one ,writ 阅读全文
posted @ 2010-12-20 22:36 cosa7 阅读(112) 评论(0) 推荐(0)