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"

How do I view a stored procedure in sql server query?

886

---

What are the grouping functions?

889

---

Explain foreign key in sql server?

974

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

850

---

Explain some stored procedure creating best practices or guidelines?

870

---

How to change server name in sql server?

1098

---

What is set nocount on?

893

---

Does a sql server 2005 select statement require a from?

970

---

What is an index in a database?

922

---

Differentiate between mongodb vs. Sql server?

1032

---

What is meant by dirty read?

950

---

What is a data source file?

922

---

Can I use sql azure as a backup with log shipping or database mirroring?

156

---

What are different types of database indexes?

1011

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

964

---