Answer Posted / deepak rawat

The tables "INSERTED" and "DELETED" are called magic tables
of the
SQL Server. We can not see these tables in the data base.
But we can access these
tables from the "TRIGGER"

When we insert the record into the table, the magic
table "INSERTED" will be created
In that table the current inserted row will be available.
We can access this
record in the "TRIGGER".


When we delete the record from the table, the magic
table "DELETED" will be created
In that table the current deleted row will be available. We
can access this
record in the "TRIGGER".

Following code Explain the magic table "DELETED"

CREATE TRIGGER LogMessageON EMPFOR DELETEAS DECLARE
@EMPNAME varchar(50) SELECT @EMPNAME= (SELECT EMPNAME
FROM DELETED) INSERT INTO LOGTABLE(UserId,Message) values
(@EMPNAME,'Record Removed')GO


The magic tables "INSERTED" and "DELETED" are main concept
of the "TRIGGER".
By using these tables we can do lot of useful
functionalities. The above code is
used to update the "LOGTABLE"

What are the five characteristics of good data?

918

---

Explain what are the database objects? : SQL Server Architecture

1077

---

How to find the service pack installed? : sql server database administration

1023

---

How to use group functions in the select clause in ms sql server?

1052

---

How to make a remote connection in a database?

977

---

How do I completely remove sql server instance?

1100

---

Do you know what are the differences between lost updates and uncommitted dependencies?

1081

---

Why do we use non clustered index?

1082

---

What is ddl and dml commands?

903

---

How to select true false based on column value in sql server?

1032

---

what types of replication are supported in sql server? : Sql server database administration

1044

---

What is set nocount on?

938

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1013

---

Explain different types of Normalization.

1831

---

Can we add a cpu to sql server?

1011

---