title: Where can I SET DEADLOCK_PRIORITY in my stored procedure?
body: <p>I am unsure as to where I can use the </p>
  
  <pre><code>SET DEADLOCK_PRIORITY...
  </code></pre>
  
  <p>command in my stored procedure. Does it need to be before I begin a transaction? Or can it be anywhere in the transaction?</p>
  
  <p>Thanks all!</p>