Article View: microsoft.public.vb.database
Article #3Re: Limiting SELECT output from line X to line Y ??
From: Li Jianguo
Date: Sun, 15 Oct 2000 04:50
Date: Sun, 15 Oct 2000 04:50
46 lines
3519 bytes
3519 bytes
I suggest that you use the ADO RecordSet Object for you purpose.
Ernest 'OERNii' Beinrohr wrote:
> Hi there, is there a possibility in MS SQL server 7 to limit the output
> from a select query per LINES ?????? (not where)
> Like:
>
> select * from table limit 1000,1100
> (this should get me only the lines 1000 - 1100)
>
> I need this to make "pages" on my www search results.
>
> Thanx for help.
> PS: sorry for crossposting
> --
> ==========================-------------------------------------------------
> OERNii - Ernest Beinrohr | @@@@@@ @@@@@@@@ @@@@@@@ @@@ @@@ @@@ @@@
> mailto:oernii@oernii.sk | @@! @@@ @@! @@! @@@ @@!@!@@@ @@@ @@@
> http://www.oernii.sk | !@! !!! !!!!!: !!@!@! !@! !!! !!! !!!
> #holubnik on IRCNET | :!: !:! :!: :!: !:! :!: !:! :!: :!:
> ICQ No : 28153343 | : : : : :: :: : : : :: : : :
--
/// \\\
//// \||
(\ _ _ /
(- @ @ /
+------------oOOo -- oOOo-------------------------------+
| \_/ |
| Li Jianguo (James Li), Dr. |
| Director |
| Computing Laboratory |
| Faculty Of Mathematical Sciences |
| 2204 New Science Building |
| Tsinghua University |
| Beijing 100084 |
| Tel: +86 (0)10 6278 7842, 6278 2362 |
| Fax: +86 (0)10 6278 7842 |
| http://faculty.math.tsinghua.edu.cn/faculty/~jli/ |
| Email: james.li@263.net |
| o... |
+---------.ooO-----( )----------------------------------+
( ) (_/
\_)
Technical Details
Message-ID:
<39E93778.6BE0A5EF@263.net>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!newsfeed.direct.ca!look.ca!feed-out.newsfeeds.com!newsfeeds.com!feed.newsfeeds.com!newsfeeds.com!news.netfront.net!newsgate.cuhk.edu.hk!sunlight.pku.edu.cn!pku!not-for-mailReferences:
<39E82003.E697B472@oernii.sk>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff490,27940dede5576130 X-Google-Attributes: gidff490,public X-Google-Thread: 104de1,27940dede5576130 X-Google-Attributes: gid104de1,public X-Google-Thread: 10be7f,27940dede5576130 X-Google-Attributes: gid10be7f,public X-Google-Thread: 103747,27940dede5576130 X-Google-Attributes: gid103747,public X-Google-ArrivalTime: 2000-10-14 21:49:24 PST Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!newsfeed.direct.ca!look.ca!feed-out.newsfeeds.com!newsfeeds.com!feed.newsfeeds.com!newsfeeds.com!news.netfront.net!newsgate.cuhk.edu.hk!sunlight.pku.edu.cn!pku!not-for-mail From: Li Jianguo <james.li@263.net> Newsgroups: microsoft.public.vb.database,comp.databases.ms-sqlserver,microsoft.public.vc.database,cz.comp.microsoft.sql Subject: Re: Limiting SELECT output from line X to line Y ?? Date: Sun, 15 Oct 2000 12:50:00 +0800 Organization: Dept Math, Tsinghua Univ Lines: 48 Message-ID: <39E93778.6BE0A5EF@263.net> References: <39E82003.E697B472@oernii.sk> NNTP-Posting-Host: 166.111.11.153 Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: sunlight.pku.edu.cn 971585825 22363 166.111.11.153 (15 Oct 2000 04:57:05 GMT) X-Complaints-To: postmaster@pku.edu.cn NNTP-Posting-Date: 15 Oct 2000 04:57:05 GMT To: Ernest 'OERNii' Beinrohr <oernii@oernii.sk> X-Mailer: Mozilla 4.74 [en] (Windows NT 5.0; U) X-Accept-Language: en