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"

can any body tell me how to know the password of current user in sql server

2076

---

Difference between connected and disconnected database in .net with sql server?

1103

---

What is a partitioned view?

1002

---

Explain “@@rowcount” and “@@error” in sql server?

1095

---

How to optimize stored procedure optimization?

897

---

How to convert character strings into numeric values?

1102

---

What do you understand by integration services in sql server?

968

---

What is the rdl file?

138

---

What is mapping schema?

1034

---

What is it unwise to create wide clustered index keys?

1009

---

What is the difference RDBMS and Graph Database?

1053

---

What is difference between aggregate and analytic function?

939

---

Explain about sql server login?

1092

---

What is the purpose of the model database?

1018

---

what are the different types of replication you can set up in sql server? : Sql server database administration

1031

---