General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
RecNo() from MSSQL?
I am trying to figure out how to get a set of rows/records from MSSQL. This is for a nightly batch process where I need to grab just chunks of the table at a time. If this was VFP I would
"select * from table where recno() between 1 and 4000"
and then
"select * from table where recno() between 4001 and 8000"
What is the MSSQL equivalent?
Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only