Actually, the syntax and methodology are completely different, I just failed to update the comments. The SQLServer 2005 method uses an identity field and a subselect to accomplish pagination, whereas in SQLServer 2012 they have added a "real" limit and offset capability which is much more optimized. I will update the comments in my implementation.