摘要:其实基本上有三种方法:1、使用SQL Server 2005中新增的ROW_NUMBER几种写法分别如下: 1SELECT TOP 20 * FROM (SELECT2 ROW_NUMBER() OVER (ORDER BY Namec) AS RowNumber,3 *4FROM5 dbo.mem_member) _myResults6WHERE7 RowNumber > 100...
阅读全文
摘要:原文链接:http://blog.csdn.net/shadowsky/archive/2007/04/02/1548827.aspxImports SystemImports System.WebImports System.Web.CachingNamespace DRMSystem.Common.Caching Public MustInherit Class DataCacheAbs...
阅读全文