title: Stored Procedure returning a string?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/13571263/conversion-failed-when-converting-the-nvarchar-value-internet-explorer-3-origin">Conversion failed when converting the nvarchar value ‘Internet Explorer 3 original’ to data type int</a>  </p>
  </blockquote>
  
  
  
  <p>So I created this following simple stored procedure:</p>
  
  <pre><code>CREATE PROCEDURE test
  AS
  BEGIN
      RETURN 'works!'
  END
  GO
  </code></pre>
  
  <p>I then wanted to execute it by firing the following statement:</p>
  
  <pre><code>EXEC test
  </code></pre>
  
  <p>Why am I getting the following error all the time?</p>
  
  <p><strong>Conversion failed when converting the varchar value 'works!' to data type int.</strong></p>
  
  <p>Oh and btw, (when) is it necessary to have the GO-statement in the end of a stored procedure? I guess it takes no effect here since it will jump out of the procedure when I am returing my @out String.</p>