title: Stored procedure delete query
body: <p>I have stored procedure:</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[k_ShoppingCart_DELETE]
  
  @cartGUID nvarchar
  
  AS
  
  DELETE FROM
    [dbo].[k_ShoppingCart]
  WHERE
    CartGUID = @cartGUID
  </code></pre>
  
  <p>When I execute this,</p>
  
  <pre><code>exec dbo.k_ShoppingCart_DELETE '32390b5b-a35a-4e32-8393-67d5629192f0'
  </code></pre>
  
  <p>Result: 0 row (s) affected.</p>
  
  <p>But, when I try this query:</p>
  
  <pre><code>Delete FROM k_ShoppingCart Where CartGUID = '32390b5b-a35a-4e32-8393-67d5629192f0'
  </code></pre>
  
  <p>Result: 2 rows affected.</p>
  
  <p>What is wrong with this?</p>