what is magic table in sql server

What is Magic Table in SQL Server

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
       SELECT * FORM INSERTED
       SELECT * FORM DELETED
END


GO
ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

www.code-sample.com/. Powered by Blogger.
^