LIMIT statements and MSSQL/ODBC
| From: | Michael Geier | Date: | Fri, 29 Dec 2000 14:38:45 +0000 |
| Subject: | LIMIT statements and MSSQL/ODBC | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-general+get-32204@lists.php.net to get a copy of this message | ||
I have noticed a few emails flying around trying to use the following type
of query against a MS SQL db.
SELECT fields FROM table WHERE field = "blah" LIMIT 10
As many of us have found out, Microsoft does not support the LIMIT
qualifier. However,
SELECT TOP 10 fields FROM table WHERE field = "blah"
will function the same. I currently don't know whether a range can be used
here, but I hope this helps some people on the list.
Michael Geier
CDMSports Systems Administration
EMail: mgeier@cdmsports.com