[PHP-DB] LIMIT statements and MSSQL/ODBC From: Michael Geier (mgeier <email protected>)
Date: 12/29/00

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 <email protected> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>