paging with STORED PROCEDURE - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

paging with STORED PROCEDURE

Author

Topic

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2006-04-25 : 07:39:59

how can i buld a paging system using sql server?
thnaks in advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-04-25 : 08:16:23

What paging system are you referring to ? Please provide more detail information

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-25 : 09:04:50

Refer this
http://weblogs.sqlteam.com/jeffs/archive/2003/12/22/672.aspx

Madhivanan

Failing to plan is Planning to fail

Kristen
Test

22859 Posts

Posted - 2006-04-25 : 10:40:40

+1 for Jeff's method

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2006-05-11 : 02:41:57

1 question about rowcount :
if in a SP i set the ROWCOUNT to 10
must i at the end of the SP to set it to 0??
if i donmt do so will it effect all queries in the system that users do>??

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-05-11 : 02:50:34

If there are select statements after that process that may be affected. It is safe to set it to 0 once the scope is finished

Madhivanan

Failing to plan is Planning to fail

Kristen
Test

22859 Posts

Posted - 2006-05-11 : 04:44:41

Slight clarification Madhi:

"If there are ~~select~~ ANY statements after that process that may be affected"

Kristen

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-05-11 : 05:06:14

Thanks Krsiten

Madhivanan

Failing to plan is Planning to fail

robertmazzo
Starting Member

1 Post

Posted - 2006-05-11 : 10:31:40

For Sql Server 2K, I still haven't discovered a paging system (i.e. I'm trying to implement paging in my web application using the Asp.Net 2.0 Repeater control). Any ideas ?

In any case, ScottGu's web log shows something interesting using Sql 2005 if you're interested in reading about the new Row_Number() function :

http://weblogs.asp.net/scottgu/archive/2006/01/07/434787.aspx

Good day.
Bob

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources