How to execute Stored Procedure from Laravel

php sql-server laravel stored-procedures laravel-5

Try something like this

DB::select('exec my_stored_procedure("Param1", "param2",..)');

DB::select('exec my_stored_procedure(?,?,..)',array($Param1,$param2));

Try this for without parameters

DB::select('EXEC my_stored_procedure')

php sql-server laravel stored-procedures laravel-5

You can also do this:

DB::select("CALL my_stored_procedure()");

php sql-server laravel stored-procedures laravel-5

for Laravel 5.4

DB::select(DB::raw("exec my_stored_procedure"));

if you want to pass parameters:

DB::select(DB::raw("exec my_stored_procedure :Param1, :Param2"),[    ':Param1' => $param_1,    ':Param2' => $param_2,]);

CodeHunter