> I am just joining this list so if this has been covered in the past I
> apologize.  I am working with MS SQL and would like the functionality
> MySQL's limit function provides.  I understand that MS SQL has no such
> command or equivalent. Has someone found a way to use standard (or MS
> specific) SQL to achieve the same goal?  I have seen bits and pieces
> code
> and ideas here and there, but nothing seems to work.  Any advice would
> appreciated.

In addition to the TOP suggestions, you may want to check out some of
the Abstraction layers out there, i.e. PEAR or ADOdb. I'm pretty sure
they replicate the LIMIT function somehow. You can use one of those
programs or just take when they do and adapt to your needs.

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to