What are magic tables in SQL and how can we use them?
Chetana Barot
when we use trigger inserted and deleted data are stored in temporary table those table are called magic tables
two Magic Tables SQL(Trigger)Inserted Deleted
Magic tables are internal tables in SQL and we can use them through triggers only. Refer this link for detailed answer: http://www.c-sharpcorner.com/UploadFile/rohatash/magic-tables-in-sql-server-2012/