title: How to execute Stored Procedure from Laravel - SQL Server
body: <p>I have the following stored procedure:</p>
  <pre><code>ALTER procedure [dbo].[spx_kasir_verifikator_GetData_web]
  @id_verifikator int
  as
  begin
      SELECT * FROM tb_kasir_set_verifikator 
      WHERE tb_kasir_set_verifikator.id_verifikator = id_verifikator;
  end
  </code></pre>
  <p>Controller:</p>
  <pre><code>public function show($id_verifikator)
  {
      $setverifikator = DB::select(&quot;exec spx_kasir_verifikator_GetData_web ?&quot;,[$id_verifikator]);
      dd($setverifikator);
  }
  </code></pre>
  <p>And I'm trying to call this procedure in Laravel 8, I need to display just one id or by id_verifikator but it's always showed all data. How I solve this?</p>