Paging in MSSQL 2005-Greater? Help
SELECT SQL_CALC_FOUND_ROWS
Users.user_id, Users.user_fname, Users.user_lname, Users.user_email, Users.user_isActive
FROM wiki_users as Users
WHERE Users.user_isActive =
LIMIT
SELECT found_rows() AS foundRows
First of all, do you see any problems with this approach?
Second, how would I reproduce this in MSSQL?