Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old June 9th, 2003, 03:04 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: abu dbabi, , United Arab Emirates.
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default sql server 2000 rownum

Hi all,

please inform there is rownum field available in sql server 2000.
how can select / see the rownum field ?

as in oracle rownum, we " select rownum from tablename"
it display all rownum.

how can we past our query result from the sql server 2000 database
any suggestion that sql server query become paster ?
display result quickly.

regards.

Mateen Martin
mateenmohd@hotmail.com
  #2 (permalink)  
Old June 9th, 2003, 03:14 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi Mateen,

A 0.0005 second query in Google (http://www.google.com/search?hl=en&l...+Server+oracle) brings to you this article:

http://vyaskn.tripod.com/oracle_sql_...quivalents.htm

which in turn brings you to this article:

http://support.microsoft.com/default...;EN-US;q186133

which answers your question.

Use Google wisely. It will often give you the correct answer and faster than posting a question to this list......


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rownum is SQL SERVER rubina SQL Server 2000 3 December 2nd, 2006 10:57 AM
SQL Server 2000 and SQL Server 2000 CE dparsons SQL Server 2000 1 July 31st, 2006 12:59 PM
looking for access 2000 to sql server 2000 sql/que method SQL Server 2000 0 July 7th, 2005 12:46 PM
SQL SERVER 2000 AND ACCESS 2000 ckentebe SQL Server 2000 3 June 17th, 2004 08:50 PM
rownum field in sql server mateenmohd SQL Server 2000 2 June 12th, 2003 04:48 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.