在SQL Server中插入表的机制是什么?

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.I have been having a discussion with my manager