Active record, offset limit with mssql

Active record, offset limit with mssql

El Forum
Unregistered

07-09-2009, 09:07 AM

[eluser]kgill[/eluser]
[quote author="Dam1an" date="1247167131"]wtf! How can any self respecting database not support limit?

[/quote]

None of the enterprise level DB's support limit, the best you can hope for from Oracle, DB2 & MS SQL is selecting the first X rows, no offset without doing some SQL trickery.

Messages In This Thread

Active record, offset limit with mssql - by El Forum - 07-09-2009, 07:15 AM

Active record, offset limit with mssql - by El Forum - 07-09-2009, 07:50 AM

Active record, offset limit with mssql - by El Forum - 07-09-2009, 08:00 AM

Active record, offset limit with mssql - by El Forum - 07-09-2009, 08:04 AM

Active record, offset limit with mssql - by El Forum - 07-09-2009, 08:13 AM

Active record, offset limit with mssql - by El Forum - 07-09-2009, 08:18 AM

Active record, offset limit with mssql - by El Forum - 07-09-2009, 08:22 AM

Active record, offset limit with mssql - by El Forum - 07-09-2009, 08:54 AM

Active record, offset limit with mssql - by El Forum - 07-09-2009, 09:07 AM

Active record, offset limit with mssql - by El Forum - 07-09-2009, 09:15 AM

Active record, offset limit with mssql - by El Forum - 07-09-2009, 02:32 PM

Active record, offset limit with mssql - by El Forum - 07-13-2009, 06:22 PM