sql server 分页查询
var sql = @"SELECT w2.n, w1.* FROM dbo.[User] w1 RIGHT JOIN (
SELECT TOP " + page*rows+ @" row_number() OVER(ORDER BY ID DESC) n, ID FROM dbo.[User]
) w2
on w1.ID = w2.ID WHERE w2.n > " + (page-1)* rows + " ORDER BY w2.n ";
SELECT TOP " + page*rows+ @" row_number() OVER(ORDER BY ID DESC) n, ID FROM dbo.[User]
) w2
on w1.ID = w2.ID WHERE w2.n > " + (page-1)* rows + " ORDER BY w2.n ";
