Hi,
I'm looking at using MS SQLServer 2005 and having some problems with the
LIMIT command that I used in MYSQL.
It doesn't appear to exist in MS SQLServer 2005, anybody know what the
command is in MS SQLServer..

Thanks

Wayne

Google shoudl be your freiend:

http://groups.google.de/group/comp.databases.ms-sqlserver/browse_frm/thread/4b26f5f95a8d831b/cf0a3edf997d1188?tvc=1&q=limit+mysql+command&hl=de#cf0a3edf997d1188

HTH, Jens Suessmeyer.

Show quoteHide quote

You've got to be joking!!!! This is rediculious!!!!

How come MySQL has the LIMIT function and a big company like Microsoft can't
include this feature!!!!!

Are there any other alternatives?

Thanks

Wayne

As far as I know MYSQL didn´t implemented many features in their versions
too, so perhpas the the UNION statement which was late implemented in V4,
this even was some kind of joky to me :-)

If you want to use the NON-Ansi compliant statement LIMIT you have to do
some logic on your own:

Select TOP 10 * CUSTOMERS
Where CustomerID NOT IN
(
    SELECT TOP4 CustomerIDFrom Customers Order By CustomerID
)
Order by CustomerID


HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---


Show quoteHide quote

People have to decide one way or the other.  Are they going to bitch that
Microsoft HAS propritary, non-ANSI standard commands, or bitch that they
don't?  You can't have it both ways.  Besides, there are plenty of better
ways to facilitate paging than a stupid LIMIT keyword (which if you google
the mysql groups you will see that it has several faults).

If you really really really think that this silly shortcut is a big bonus
then please go use MySQL.

So what is the best way to implement paging using MS SQLServer.
I want to use MS SQLServer but at the moment can't seem to find a good
solution for implementing paging..

Here are several:

http://www.aspfaq.com/show.asp?id=2120



Rick Sawtell
MCT, MCSD, MCDBA

Most major SQL implementations contain their own proprietary extensions that
allow for specialized functionality, so it is not really surprising that
MySQL has a command that MS SQL Server does not.

As for an alternative, the link provided by Jens Süßmeyer shows you how to
construct the equivalent SELECT statements in SQL Server.

Show quoteHide quote

Case Statement?
View Explaination
Index Question
Warning: Null value is eliminated (causing sproc to fail)
Query urgent