title: What are the mechanics of the inserted table in SQL Server?
body: <p>I have been having a discussion with my manager about the behaviour of the inserted table in Sql Server.  He explained to me briefly his understanding of which I have concluded it sounds thread specific.  He is a busy man and does not always have time to go into massive detail.  I would like to understand more about how the inserted table(s) work.</p>
  
  <p>When there are more than one inserted tables, what makes them unique, are they aliased?</p>
  
  <p>Do they then get discarded at the close of each thread?</p>
  
  <p>Are they even thread specific so to speak?</p>
  
  <p>I appreciate this may not be an ideal question for the site, but there is a wealth of knowledge on here between you helpful lot.</p>
  
  <p>Cheers</p>