note 10284 added to Microsoft SQL Server functions
| From: | steeven at kali dot com dot cn | Date: | Sun, 24 Dec 2000 08:07:11 +0000 |
| Subject: | note 10284 added to Microsoft SQL Server functions | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-9049@lists.php.net to get a copy of this message | ||
IMPORTANT NOTEs:
1. results sets are not supported, only the first result set can be retrieved. for example:
SELECT 1
SELECT 3,5
Only the first result set can be fetch. Use a Union instead.
2. Each fetch to cursor will get a result set. Fetch a large quantity row sets will raise the
server's overhead on network. try other way instead.
3. The very usefull advantage of ADO is that muti-result set are supported. the core function is
sp_cursorxxxxx. You can use it with a muti-record set support client. I'm very disapointed that
PHP has not support it now.
http://www.php.net/manual/ref.mssql.php