pagination with stored procedures

Wrox Programmer Forums

		Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
pagination with stored procedures

SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

August 7th, 2003, 07:52 AM

neribocchi neribocchi is offline

neribocchi is offline

Registered User

Join Date: Aug 2003

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

Default

pagination with stored procedures

What is the best method to implements, pagination with a stored procedures ?.

Neri Bocchi

Old

August 7th, 2003, 06:35 PM

David Cameron David Cameron is offline

David Cameron is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 215

Thanks: 0

Thanked 0 Times in 0 Posts

Default

See:
http://www.adopenstatic.com/experime...dsetpaging.asp

Under "The adOpenForwardOnly/#Temp Table Method" there an example of paging using a recordset.

regards
David Cameron

Old

August 8th, 2003, 03:10 PM

neribocchi neribocchi is offline

neribocchi is offline

Registered User

Join Date: Aug 2003

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

Default

TKS... Luis.

Neri Bocchi

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Stored Procedures	umeshtheone	SQL Server 2000	0	June 19th, 2007 01:08 AM
Stored Procedures	itHighway	SQL Server 2000	3	November 23rd, 2005 10:08 AM
Stored Procedures	stu9820	ASP.NET 1.x and 2.0 Application Design	2	January 15th, 2005 04:09 AM
Using Stored Procedures	lintacious	Classic ASP Basics	1	August 12th, 2003 04:06 PM