Anil Singh | Code-sample.com

The tables 'INSERTED', 'UPDATED' and 'DELETED' are called Magic Table of SQL Server. We can't see the table in SQL Server db. It's created automatically and manage by SQL Server. Magic table contain the recent Inserted, Updated and deleted data. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author:           <Author,,Anil Singh> -- Create date: <05-09-2014,,> -- ============================================= CREATE TRIGGER MAGICTABLEDATA    ON [dbo] . [Users]    AFTER INSERT , DELETE , UPDATE AS BEGIN        -- SET NOCOUNT ON added to prevent extra result sets from        -- interfering with SELECT statements.        SET NOCOUNT ON ;        -- Insert statements for trigger here ...