title: trigger and transactions on temporary tables
body: <p>can we create trigger and transactions on temporary tables?</p>
  
  <p>when user will insert data then , if it is committed then the trigger would be fired , and that data would go from the temporary table into the actual tables.</p>
  
  <p>and when the SQL service would stop, or the server would be shutdown, then the temporary tables would be deleted automatically.</p>
  
  <p>or shall i use an another actual table , in which first the data would be inserted and then if it is committed then the trigger would be fired and the data would be sent to the main tables and then i would execute a truncate query to remove data from the interface table, hence removing the duplicate data.</p>