Date: 03/25/05 (SQL Server)    Keywords: mysql, database, sql

I'm used to working with MySQL and I have to make this forray into SQL server. So, I need a quick bit of help.

I need to be able to browse through a database one record at a time. For that, I guess I need a way to give my query a start row and. I can end it just fine. What should I use? And how do I figure out what row I am currently on. With MySQL theres the LIMIT clause and I know thats not available in SQL server.

Thanks in advance.

Source: http://www.livejournal.com/community/sqlserver/22596.html