對這文章發表回應

 1
 2
 3
 4
 5
 6
 7
 8
 9
10

25
SELECT TOP @PageSize *
FROM
}
WHERE
(   IN
	({具唯一跟可排序性欄位}
	 }
	 條記錄
DESC

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

25
FROM
(
    SELECT
        *, ROW_NUMBER() OVER (as RowId
    FROM
        }
    WHERE
        Conditions
) AS vw
WHERE
    RowId AND @PageIndex * @PageSize

1
2
3
4
5
6
7
8

25
FROM
    }
BY
    ASC/DESC
ROWS
ONLY;