|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 9th, 2004, 10:19 AM
|
|||
|
|||
|
MSSQL: Doing a MINUS
Dear all,
How can I do a MINUS operation in MSSQL? In fact the purpose is doing paging in a ASP.NET webpage, for example I want to display 10 records in a page, so the second page will be (select top 20 * in table1 where ...) MINUS (select top 10 * in table1 where ...) Anyone can suggest how to do a MINUS? Or are thereany better methods to select a certain range of records in a recordset? Thanks. Regards, Ivan
|
|
#2
February 9th, 2004, 09:06 PM
|
||||
|
||||
|
There are more standardized ways of doing this. See:
http://aspnet.4guysfromrolla.com/articles/091003-1.aspx http://www.dnzone.com/ShowDetail.asp?NewsId=158 http://www.codeproject.com/aspnet/dspaging.asp
|
|
| Viewing: ASP Free Forums > Database > SQL Development > MSSQL: Doing a MINUS |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
