Re: Paging support using MS SQL

This is technically a question for another list since FreeTDS is just a means of connecting, not what you do with that connection. That said, Wikipedia might be a good place for you to start before Googling onward. 

http://en.wikipedia.org/wiki/Select_(SQL)#Limiting_result_rows

I use the TOP and ROW_NUMBER for limit/offset support in the SQL Server Adapter for ActiveRecord.
https://github.com/rails-sqlserver/activerecord-sqlserver-adapter


 - Ken

> I apologize in advance for a (probably) RTFM question - have limited
> access to the DB guy for the remote MS SQL server I've been connecting
> to using FreeTDS on CentOS and having trouble finding the right docs
> (answer), have only done simple form processing in the past myself.
> Can someone point me to the correct docs on how to use paging, if
> supported?
> 
> I'm currently able to execute stored procedures and handle simple recordsets.