SQLServer 分页
方法1：适用于 SQL Server 2000/2005SELECTTOP页大小*FROMtable1WHEREidNOTIN(SELECTTOP页大小*(页数-1) idFROMtable1ORDERBYid)ORDERBYid方法2：适用于 SQL Server 2000/2005SELECTTOP页大小*FROMtable1WHEREid>(SELECTISNULL(MAX(id),0) FROM (SELECTTOP页大小*(页数-1) idFROMtable1ORDERBYid )A)ORDERBYid方法3：适用于 SQL Server 2005SELECTTOP页大小*FR
