title: Select last updated row ID and last deleted row ID in trigger before they occur in SQL Server
body: <p>I need to get the id of the updated row in a table to use it to update another table via trigger</p>
  
  <p>Also need to get the id of the deleted row in a table to use it to update another table via trigger</p>
  
  <p>How can I do this?</p>
  
  <p>Is there any built in functions in SQL Server?</p>
  
  <p>If not what kind of trick that can help to accomplish this</p>