How to call SQL Server Stored procedure in laravel?

Here is an example:

DB::statement('CALL sp_user_add(:name, :email, :password);',
                array(
                    'name' => $name,
                    'email' => $email,
                    'password' => $password
                )
            );

You can easily call stored procedure in laravel in two ways

• using parameter
• without using parameter

Without Using parameter

class CheckController extends Controller
{
    public function callProcedure()
    {
     // Calling Stored Procedure from MySQL
     $alluser = DB::select('call getalluser()'); 
     return $alluser;
    }
}

Using parameter

class CheckController extends Controller
{
    public function callProcedure($id)
    {
     // Calling Stored Procedure from MySQL
     $specificuser = DB::select('call getspecificuser(?)',array($id));
     return $specificuser;
    }
}

You can refer the following article for better understanding How to call stored procedure in laravel