Re: Converting code to work with MS SQL from MySQL
| From: | Rasmus Lerdorf | Date: | Sat, 24 Aug 2002 16:50:51 +0000 |
| Subject: | Re: Converting code to work with MS SQL from MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-113952@lists.php.net to get a copy of this message | ||
> For the most part MS-SQL's features are a super-set of MySQL, but
> there are some things in MS-SQL that are missing (at least in version
> 7.0 which is the only one I have any experience with). The main one,
> and the one you're most likely to run into, is that MS-SQL does not
> have a LIMIT clause. My understanding is that LIMIT is an extension
> to the SQL92 standard.
;) Extension of the standard... I like that. No, the LIMIT clause
doesn't adhere to any standard anywhere. And I know this because I
came up with this LIMIT clause years ago for mSQL. I read no standards, I
just added a feature I needed and arbitrarily called it LIMIT.
-Rasmus