note 10284 deleted from ref.mssql by sniper
| From: | sniper@php.net | Date: | Mon, 17 Nov 2003 22:57:03 +0000 |
| Subject: | note 10284 deleted from ref.mssql by sniper | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-60510@lists.php.net to get a copy of this message | ||
Note Submitter: steeven@kali.com.cn
----
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.