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:
Users.user_id, Users.user_fname, Users.user_lname, Users.user_email, Users.user_isActive
FROM wiki_users as Users
WHERE Users.user_isActive =
SELECT found_rows() AS foundRows
First of all, do you see any problems with this approach?
Second, how would I reproduce this in MSSQL?