Click here to Skip to main content
13,150,472 members (34,514 online)
   

Database

 
AnswerRe: Cassandra or MySQL? Pin
PIEBALDconsult7-Jan-13 12:53
memberPIEBALDconsult7-Jan-13 12:53 
QuestionOracle Application expres Pin
Fred Andres6-Jan-13 11:52
memberFred Andres6-Jan-13 11:52 
AnswerRe: Oracle Application expres Pin
Chris Meech6-Jan-13 13:57
memberChris Meech6-Jan-13 13:57 
GeneralRe: Oracle Application expres Pin
Fred Andres7-Jan-13 8:32
memberFred Andres7-Jan-13 8:32 
AnswerRe: Oracle Application expres Pin
Shameel7-Jan-13 3:45
memberShameel7-Jan-13 3:45 
GeneralRe: Oracle Application expres Pin
Fred Andres7-Jan-13 8:32
memberFred Andres7-Jan-13 8:32 
QuestionSQL paging with search Pin
Lance Parker6-Jan-13 2:11
memberLance Parker6-Jan-13 2:11 
AnswerRe: SQL paging with search Pin
jschell6-Jan-13 5:19
memberjschell6-Jan-13 5:19 
Lance Parker wrote:
Is there a way of replicating this behavior in SQL o


Your question about what "behavior" you want to replicate is confusing but yes you can implement paging in SQL.

Basic steps.
1. Create your SQL with appropriate search parameters. You should still use parametrized values.
...a. If you have just a couple of items you can hard code the SQL.
...b. With more than a couple items create the SQL dynamically.
2. Apply appropriate ordering to the SQL. This can include creating it dynamically.
3. Apply paging (dynamic SQL again) See the following link

SQL Server 2005 Paging Results[^]


At the business level you might also want to consider what happens to paging if the data being paged changes underneath. Very common answers are
1. It won't, so there is no problem.
2. It won't in relation to the user because the work flow and usage insures that.

Be VERY sure that you analyze this at the business level before deciding that this could be a problem.

Also you should require sufficient search constraints to insure that no single result has lot of pages. Three pages is ok, 100 isn't. If someone claims otherwise then note that users do not randomly seek data. They know what they are looking for. So make them tell you it. Paging is a convenience so they don't have to tell you everything in detail but ignoring it can inhibit rather than help workflow.
GeneralRe: SQL paging with search Pin
Lance Parker7-Jan-13 8:23
memberLance Parker7-Jan-13 8:23 
GeneralRe: SQL paging with search Pin
jschell7-Jan-13 9:12
memberjschell7-Jan-13 9:12 
QuestionI want to ask query related to mysql Pin
manisharathore5-Jan-13 7:32
membermanisharathore5-Jan-13 7:32 
AnswerRe: I want to ask query related to mysql Pin
Mycroft Holmes5-Jan-13 11:03
memberMycroft Holmes5-Jan-13 11:03 
Questionproblem in ado.net with access 2010 Pin
Achilles843-Jan-13 23:20
memberAchilles843-Jan-13 23:20 
AnswerRe: problem in ado.net with access 2010 Pin
Mycroft Holmes4-Jan-13 13:55
memberMycroft Holmes4-Jan-13 13:55 
Questionhow to cast real data type in sql server 2005 Pin
Auf Klarung2-Jan-13 22:55
memberAuf Klarung2-Jan-13 22:55 
QuestionRe: how to cast real data type in sql server 2005 Pin
Eddy Vluggen4-Jan-13 22:52
memberEddy Vluggen4-Jan-13 22:52 
QuestionSql server like clause Pin
rubonkumar28-Dec-12 4:44
memberrubonkumar28-Dec-12 4:44 
AnswerRe: Sql server like clause Pin
Richard MacCutchan28-Dec-12 6:05
mvpRichard MacCutchan28-Dec-12 6:05 
AnswerRe: Sql server like clause Pin
PIEBALDconsult28-Dec-12 6:38
memberPIEBALDconsult28-Dec-12 6:38 
GeneralRe: Sql server like clause Pin
Mike Meinz28-Dec-12 6:49
memberMike Meinz28-Dec-12 6:49 
GeneralRe: Sql server like clause Pin
rubonkumar28-Dec-12 19:08
memberrubonkumar28-Dec-12 19:08 
AnswerRe: Sql server like clause Pin
rajarao3044-Jan-13 0:50
memberrajarao3044-Jan-13 0:50 
QuestionDatabase design question Pin
DavidCrow27-Dec-12 15:22
memberDavidCrow27-Dec-12 15:22 
AnswerRe: Database design question Pin
PIEBALDconsult27-Dec-12 15:52
memberPIEBALDconsult27-Dec-12 15:52 
AnswerRe: Database design question Pin
jschell28-Dec-12 10:16
memberjschell28-Dec-12 10:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy |
Web03 | 2.8.170924.2 | Last Updated 22 Sep 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid