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 to get the definition of a trigger back?

1045

---

How can we solve concurrency problems?

1098

---

What is difference between oltp and olap?

1094

---

Tell me what is log shipping?

1032

---

What is the benefit of normalization?

1135

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2457

---

What is the difference between upgrade and migration in sql server?

1150

---

How network traffic be reduced by using the stored procedure?

1172

---

what is spatial nonclustered index

1037

---

When do you think a developer should use sql server-based cursors?

1105

---

How optimize sql query with multiple joins in sql server?

955

---

How many partitions a clustered index has by default in sql server 2012?

1139

---

What encryption security is available in sql azure?

101

---

What is a primary index?

978

---

Why use “in” clause in sql server?

1124

---