title: Codeigniter - SQL Server 2008 : How to get parameter output in Store Procedure
body: <p>I’ve a procedure in SQL Server 2008</p>
  
  <pre><code>CREATE PROCEDURE dbo.testing
      @parm varchar(10),
      @parmOUT varchar(30) OUTPUT
  AS
  BEGIN
     SELECT @parmOUT = 'parm 1 ' + @parm
  END 
  </code></pre>
  
  <p>and i have a query to access this procedure in Codeigniter frameword.
  i use sqlsrv_driver database.</p>
  
  <pre><code>$param1 = 'test';
  $param2 = '1';
  $this-&gt;db-&gt;query("dbo.testing ?,  ?", array($param1, $param2)); 
  </code></pre>
  
  <p>i’ve execute the procedure, but i can’t retrieve 2nd parameter value ($param2).</p>
  
  <p>Anyone have idea to get this 2nd parameter value??</p>
  
  <p>thanks b4</p>