Answer Posted / ajay sadyal

Hi Friends

Magic table are created when we execute the DML statement
like insert,update and delete on database..

But these magic table are not accessible directly.You can
access these table only with triggers.
Becuase these table are only in the scope of triggers.

e.g deleted and inserted are two magic table..

CREATE TRIGGER [dbo].[EMPLOYEE_trgU]
ON [dbo].[EMPLOYEE]
FOR UPDATE AS
BEGIN
declare @name varchar(40)

SELECT @name = name from deleted WTIH (NOLOCK)

-- WITH (NOLOCK) enforce the sql-server not to Lock -
-- the data if there is any transaction implemented.

-- Now Update it with another table

UPDATE tbl_employee_log
SET description = @name + ' record has been deleted
from database'


END

Hope this will help.

How to use values from other tables in update statements in ms sql server?

1177

---

How to Check if table exists in sql server?

1181

---

Explain about service Broker functions?

1084

---

What according to you is the difference between mysql and sql server performance?

1138

---

Explain having clause?

1022

---

What security features are available for stored procedure?

1073

---

What is raid and what are different types of raid levels?

1191

---

What is cube dimension? : sql server analysis services, ssas

1043

---

What is data source document?

1085

---

Relational calculus is what type of language?

1090

---

What’s the use of custom fields in report?

984

---

Explain error and transaction handling in sql server?

1056

---

What are dml triggers and types of dml triggers?

1028

---

How can I change procedure name in sql server?

1104

---

How extra digits are handled with numeric data type literals?

1024

---