title: Laravel 4 mssql stored procedure with parameters as a prepared statements
body: <p>I would like to format this working query as a prepared statement:</p>
  
  <pre><code>Route::get('procedure/{adr}/{part}/{batch?}', function($adr, $part, $batch= '') {
  
      return DB::connection('sqlconnection')-&gt;select("Procedure_Name '$adr', '$part', '$batch'");
  });`
  </code></pre>
  
  <p>Tried everything I could think of and the closest I got was this.</p>
  
  <pre><code>DB::connection('sqlconnection')-&gt;select('Procedure_Name ?, ?, ?', array("'$adr'", "'$part'", "'$batch'"));
  </code></pre>
  
  <p>This results in a error with and sql command that when used directly on the db works just fine.</p>
  
  <blockquote>
    <p>Illuminate \ Database \ QueryException
    SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'Procedure_Name'. (SQL: Procedure_Name 'VLM', '7999800', 'P20131018-29')</p>
  </blockquote>
  
  <p>What am I doing wrong?</p>