|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 16th, 2003, 08:44 AM
|
||||
|
||||
|
stored procedure to display portions of records
can you use a stored procedure to display say records 1 through 10? and then 11 through 20? etc and so on and so forth. if you can, could someone show me how?
__________________
My brain cells are like a storm trooper's armor: useless
|
|
#2
September 16th, 2003, 02:23 PM
|
|||
|
|||
|
It helps to be... just a little more specific about your question, such as explaining what database system you are using, and what procedural language you want to write this in. But really, there is no way to make this logic occur completely in the server, except for certain very odd situations. Generally, you will still need to at least maintain the count offset in your client-side environment.
__________________
The real n-tier system: FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL Amazon wishlist -- rycamor (at) gmail.com
|
|
#3
October 3rd, 2003, 08:17 AM
|
||||
|
||||
|
ok here are some more specifics, database is MSSQL7, using tsql. and i figured on keeping track of the number offset on client side. i was just looking for an example, perhaps just pseudo code. the logic portion. thanks for any help you can give.
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > stored procedure to display portions of records |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
