I have a stored procedure which returns multiple datasets (basically there are two select statements in the stored procedure). But DB::select only takes in the first data set returned by the query. I'm calling me stored procedure the following way:
$query = 'EXEC [dbo].[myStoredProcedure] \''. $param . '\'';
$result = DB::select($query);
I'm using Laravel 5.1
Please let me know what exact function to use instead of DB::select. Thanks in advance.
via Flemin Adambukulam