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.
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 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..
|