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"

Why I can not enter 0.001 second in date and time literals in ms sql server?

1104

---

Explain the use of containers in ssis and also their types?

1015

---

What is function of CUBE ?

1075

---

What is the difference between indexing and hashing?

1216

---

What are the features of Embedded SQL

1170

---

What are the new features of sql server 2012 reporting service?

141

---

What is the difference between ddl and dml?

1094

---

Describe in brief databases and sql server databases architecture.

1061

---

What is user defined stored procedures?

988

---

Write a SQL query to make a column as unique?

1070

---

How do I know if localdb is running?

994

---

What is difference between after and before?

1182

---

How much space does sql server 2016 take?

1027

---

What are sub reports and how to create them?

144

---

Explain different types of self contained sub query?

1100

---