Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-05 : 09:11:41
|
Kailash writes "Hi EveryBody,
I am developing an application with VisualBasic as Front End and Microsoft SQL Server 7.0 as Back end. I have to deal with thousands of records. So I want to have a button which call a stored procedure and which in turn can allow me to give only first 100 records. if user wants another set of records he can press this buton again and my stored procedure again fetches me another 100 next records i.e. from 100-199. This stored procedure also return a value so that I can know that there are no more records in the table.
Can you tell me how it is possible in SQL Server 7.0 stored procedure.
Looking forward for your replies.
Kailash" |
|
|
|
|
|
Functionality of limited set of records