I don’t really work with MSSQL very much and was wondering how to do pagination similar to doing it in MySQL with the LIMIT command. It’s MUCH harder in MSSQL, but here is how you do it:
SELECT * FROM (SELECT TOP [size_of_record_set] * FROM (SELECT TOP [end_record] * FROM [table] ORDER BY [field] ASC) AS tbl1 ORDER BY [field] DESC ) AS tbl2
Related Posts:
Tidbit Tuesday on PHP: Simple MySQL Database Query Function It's always great to create functions for those things you do a lot. Probably the single most common function I ...- Tidbit Tuesday on PHP: Simple MySQL Database Insert Function This builds on a function I did last week: db_query(). You can send any array straight to a MySQL ...
- PHP Function Friday: date I think the date function is extremely useful. It gives your programs an awareness of WHEN they are. You can ...
Facebook
Twitter
Digg
Sphinn
LinkedIn
Facebook Fan Page
MySQL is always lite…
Reply