I wanted to shoot out on this as I do not use MSSQL 2005 and greater too much and need help on what would be the best and great way to do record paging. I am so used to this in MySQL and you can see a sample of MySQL below:

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?