Limiting SELECT output from line X to line Y ??

Article View: microsoft.public.vb.database

Article #2

Back to microsoft.public.vb.database Previous Next

From: Ernest 'OERNii' Beinrohr
Date: Sat, 14 Oct 2000 00:00

18 lines
1886 bytes

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        |  : :  :   : :: ::    :   : :  ::    :   :    :

Technical Details

Message-ID: <39E82003.E697B472@oernii.sk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 104de1,27940dede5576130,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: 10be7f,27940dede5576130,start
X-Google-Attributes: gid10be7f,public
X-Google-Thread: 103747,27940dede5576130,start
X-Google-Attributes: gid103747,public
X-Google-Thread: ff490,27940dede5576130,start
X-Google-Attributes: gidff490,public
From: Ernest 'OERNii' Beinrohr <oernii@oernii.sk>
Subject: Limiting SELECT output from line X to line Y ??
Date: 2000/10/14
Message-ID: <39E82003.E697B472@oernii.sk>
X-Deja-AN: 681303412
Cache-Post-Path: cdwork.cvt.stuba.sk!oernii@fornax.elf.stuba.sk
Content-Transfer-Encoding: 7bit
X-Accept-Language: sk,cs,en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: usenet@news.telecom.sk
X-Trace: news.telecom.sk 971514003 3632 147.175.1.11 (14 Oct 2000 09:00:03 GMT)
Organization: http://www.axonpro.sk
Mime-Version: 1.0
NNTP-Posting-Date: 14 Oct 2000 09:00:03 GMT
Newsgroups: microsoft.public.vb.database,comp.databases.ms-sqlserver,microsoft.public.vc.database,cz.comp.microsoft.sql