MSSQL Stored Procedures Laravel 5

Question

How to run a stored procedure in laravel 5

I use:

DB::connection('sqlsrv')->select('exec SP_XXXX ?,?',array($a,$b));

error message :

SQLSTATE[IMSSP]: The active result for the query contains no fields.

stored procedure :

ALTER PROCEDURE [dbo].[SP_XXXX] (@FROMDATE DATETIME, @TODATE DATETIME)

Answer 1

You should not start naming the SP_.