Re: MSSQL HELP
| From: | Nick H. | Date: | Wed, 02 Jul 2003 19:57:14 +0000 |
| Subject: | Re: MSSQL HELP | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-20658@lists.php.net to get a copy of this message | ||
It's not as easy with MSSQL, but the TOP syntax should work.
SELECT TOP 10 user,email FROM userdb WHERE user LIKE '%b%'
Regards,
Nick H.
Network Operations Center
nickh@supportteam.net
----- Original Message -----
From: "disko_kex" <disko_kex@swedish-mushroom.com>
To: <php-windows@lists.php.net>
Sent: Wednesday, July 02, 2003 12:20 PM
Subject: [PHP-WIN] MSSQL HELP
: In MySQL is easy to page with LIMIT but it doesnt work with MSSQL. So
: how do I make it page in MSSQL?
:
: