title: SQL Server Select statement with (XLOCK,READPAST)
body: <p>I ran the following query and my records are locked now I can't read or update or delete. For testing purpose i didn't called commit tran and now these records got stuck. How can I release these locks which are already placed.</p>
  
  <pre><code>  BEGIN TRAN
  
    SELECT * from inquiry with (XLOCK,READPAST)  where inquiry_id=228563
  </code></pre>