On Wed, Jan 14, 2009 at 6:27 PM, Roan Kattouw roan.kattouw@home.nl wrote: [snip]
I knew about those, yes, but I didn't know LIMIT/OFFSET was non-standard, even though it seems to be the more widely used variant. Of course if offset handling isn't implemented at all, that's something to worry about.
[/snip]
MSSQL does something different too. The following bit of MySQL:
SELECT * FROM tbl LIMIT 5;
Would become the following in MSSQL:
SELECT TOP 5 FROM tbl;
Was definitely a headache on more than one occasion, being so used to typing limit...
-Chad