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.

Explain features of analysis services?

1079

---

Is mysql better than sql server?

1106

---

What is the simplest way to create a new database in ms sql server?

1049

---

What is the purpose of the tempdb database?

1044

---

What language is sql server written in?

1079

---

What is report server project?

155

---

Comment,Datatypes are unlimited

2106

---

Does a server store data?

953

---

Tell me what is log shipping?

1029

---

Explain subquery and state its properties?

1088

---

Why it is recommended to avoid referencing a floating point column in the where clause?

1010

---

How do I create a stored procedure in sql server?

1094

---

What the different types of Replication and why are they used?

1127

---

What are the steps you will take to improve the performance of a poor performing query?

1018

---

wat wil hapn if we give the both read and deny read permission to user?

2151

---