title: Why won't my SQL Server database show any results while running stored procedure?
body: <p>Please look at the code I created. The first block is my stored procedure that I created.</p>
  
  <p>The second block is me running the code manually, bypassing the stored procedure.</p>
  
  <p>The 3rd block is me running the code using the stored procedure.</p>
  
  <p>When I run the code without the stored procedure, I get results. When I run the code via the stored procedure, I don't get anything, even though it's presumably the same code.</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[uspCheckSaleVIN] 
      @VIN nvarchar(17)
  AS
      SELECT * 
      FROM Sales
      WHERE VIN = @VIN
  
      SELECT * 
      FROM Sales
      WHERE (VIN = 09872345098723457)
  GO
  
  uspCheckSaleVIN 09872345098723457
  </code></pre>