Try issuing an "set rowcount nnn" before your command, where nnn is the
maximum number of rows you wish. To turn it off set rowcount 0.

HTH,
Patricia.

-----Original Message-----
From: Ray O' Brien [mailto:[Email Address Removed] Sexta-feira, 30 de Novembro de 2001 09:00
To: LazyDBA.com Discussion
Subject: Slightly OT - SQL Svr Equivalent of Rownum.


Folks,

Does anyone know the SQL Svr equivalent of Oracle's rownum?

Cheers,

Ray.


************************************************************************
************************************************************************
****************************************************
IMPORTANT NOTICE
This communication contains information which is confidential and may
also be privileged. It is for the exclusive use of the intended
recipient(s). If you are not the intended recipient(s) please note that
any form of distribution, copying or use of this communication or the
information contained within is strictly prohibited and may be unlawful.
Any views or opinions presented are solely those of the sender and do
not necessarily represent those of Qualtrace Solutions.
If you have received this e-mail or any file or attachment transmitted
with it in error please notify:
Customer Care Department at Qualtrace Solutions, Business and Technology
Park, Model Farm Road, Cork, Ireland. Ph: 353-21-4817000;
e-mail:[Email Address Removed] <mailto:e-mail:[Email Address Removed]
Then delete this e-mail from your system.

************************************************************************
************************************************************************
****************************************************



--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page