Re: [PHP-DB] sybase function for MS-SQL Server

2001-06-30 Thread jong jong
I am almost crazy now after playing with these codes over 10 hours. I don't expect to call sybase_query() one by one for executing sql batch. It just doesn't work for me like what I said yesterday. Now I try to make a stored procedure for these sql batch. So I can call sybase_query() only once.

Re: [PHP-DB] sybase function for MS-SQL Server

2001-06-30 Thread Frank M. Kromann
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)