What are magic tables?

 Posted by Bhakti on 11/23/2009 | Category: Sql Server Interview questions | Views: 5612

Sometimes we need to know about the data which is being inserted/deleted by triggers in database. With the insertion and deletion of data, tables named “INSERTED” and “DELETED” gets created in SQL Server which contains modified/deleted data.
Here, “INSERTED” and “DELETED” tables are called magic tables.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response