title: Execute SQL Server stored procedure with input parameter
body: <p>Could you suggest please how to execute from Sql Server a stored procedure that receives an input parameter? I tried this but it failed:</p>
  
  <pre><code>EXEC GetFilmsInCategory('SF'); 
  </code></pre>
  
  <p>The stored procedure is correctly defined, by the way. I executed it from the visual interface and it worked, with this code generated automatically:</p>
  
  <pre><code>DECLARE @return_value int
  
  EXEC @return_value = [dbo].[GetFilmsInCategory] @CatNume = N'SF'
  
  SELECT 'Return Value' = @return_value
  </code></pre>
  
  <p>I find this automatically generated code too... lengthy as I was expecting something similar to what I initially tried: </p>
  
  <pre><code>EXEC GetFilmsInCategory('SF'); 
  </code></pre>
  
  <p>Can you fix this or offer an alternative? Thank you!</p>
  
  <p>Anna</p>