title: magic tables of triggers in sql server
body: <p>the magic tables of a trigger are emptied themselves or have to emptied explicitly? when we insert data into a table having a trigger on it, then first the data goes to the inserted magic table and then to the actual table. but after that does the inserted magic table retains its data or loses it?</p>