title: Return a value from stored procedure classic asp
body: <p>As a noob to stored procedures, I can't get my head around how to get a classic ASP (vbscript) page to return a value from a stored procedure. I can write data to a table ok, it's just retrieving stuff that has me stuck.</p>
  
  <p>If I use a very basic example. This is a stored procedure that should return a count of the records in a table:</p>
  
  <pre><code>CREATE PROCEDURE [dbo].[SP_RecordCount] 
  
  AS
  
  SELECT COUNT(*) FROM MyTable
  </code></pre>
  
  <p>What Classic ASP code (and what changes to the SPROC) would I need to write to be able to display the value in a browser?</p>
  
  <p>Once I understand how to get a basic output such as this, I should hopefully(!) be able to build on the knowledge.</p>
  
  <p>Thanks.</p>