title: Stored procedure executing and getting 1 row affected but actually in db it is not effecting
body: <pre><code>ALTER PROCEDURE [dbo].[statusupdate]
      (@userid INT, @status BIT)
  AS
  BEGIN
      UPDATE Users 
      SET @status = IsDeleted
      WHERE @userid = UserId
  END
  </code></pre>
  
  <p>I am updating only one column (<code>IsDeleted</code>) based on <code>userid</code> in the <code>Users</code> table. It is executing but not reflecting the change in the database.</p>