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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.
ASK Questions
SQL Server NodeJs TypeScript JavaScript Angular SQL Server My Book