python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions