Re: sybase function for MS-SQL Server
| From: | Frank M. Kromann | Date: | Sun, 01 Jul 2001 02:03:08 +0000 |
| Subject: | Re: sybase function for MS-SQL Server | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9994@lists.php.net to get a copy of this message | ||
Hi,
> Query Analyzer" perfectly.
> e.g.
> SP1: (works)
> CREATE PROCEDURE SP1 AS
> insert into mytable values(...)
> select * from mytable
Only one result set.
>
> SP2: (doesn't work)
> CREATE PROCEDURE SP2 AS
> select * from mytable
> select * from mytable
Two result sets
>
> SP3: (doesn't work)
> CREATE PROCEDURE SP3 AS
> insert into mytable values(...)
> insert into mytable values(...)
Two results.
The sybase extension is not written to handle multiple results in a single query. I have writteh the
code for this in the MSSQL extension, but so far this extension is only available on Windows.
- Frank