MS SQL Pagination :: Code Pin Board :: Networks

Networks » Code Pin Board » MS SQL Pagination

JavaScript is not enabled on your browser and in order to properly use Coder Profile JavaScript is required.
To view instructions on how to enable JavaScript on your browser click here.

MS SQL Pagination

Download Source Code

Author Details

Code Information

Craige ( Craige Leeder )

Pinned 5 Codes
Posted 0 Coding Articles

Send A Message
View Coders Profile

Language	SQL (Structured Query Language)
Expires	Never
Length	119 Characters (8 Lines)
Password	no password

Description

MS SQL has no LIMIT keyword, and this you must get creative with the TOP and ORDER BY keywords, using sub-queries.

Will SELECT rows 5 - 10

SELECT TOP 5 DT.*
FROM
(SELECT TOP 10 *
FROM tblEX
WHERE 1=1
ORDER BY id DESC
) DT
ORDER BY id ASC

Back To Code Pin Board

Post New Code

Please login to post comments.

Latest News About Coder Profile

RSS News Feed

Coder Profile Poll

Which sounds better on your coder profiles, and makes more sense to you (think twitter, facebook, etc)?

Followers / Following
Fans / Following
Fans / Fan Of

please login to cast your vote
and see the results of this poll

Latest Coder Profile Changes

Coder Profile was last updated
3.20 Years Ago

RSS Development Blog Feed

Official Blog :: Make A Donation :: Credits :: Contact Me
Terms & Conditions :: Privacy Policy :: Documents :: Wallpapers