Answer / punit chauhan

whenever a trigger is fire in response to an insert, delete and update statement.
Two special tables create, these are the inserted and deleted tables, they are also referred as magic tables.

* whenever we insert any record into the table then trigger use inserted table.

* whenever we delete any record into the table then trigger use deleted table.

* whenever we update any record into the table then trigger use inserted and deleted tables.

Answer / rani

Refer this link which nicely demonstrates the Magic Table.
Magic Table are the INSERTED and DELETED tables which we
cannot see from the database, but can be accessed using
Triggers.
When a new row is added an INSERTED table gets created with
the inserted row. Similarly when a row is updated a DELETED
table is created with the deleted row. For update the old
data is moved to the DELETED table and the new updated row
gets created in the INSERTED table.

What is the difference between cross join and Full outer join?

1 Answers   HP, Standard Bank,

---

What are the default system databases in sql server 2000?

0 Answers  

---

Explain ms sql server reporting services vs crystal reports?

0 Answers  

---

last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,

---

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

2 Answers   Apollo,

---

Are all views updatable ?

0 Answers   MCN Solutions,

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

Explain features of analysis services?

0 Answers  

---

What are the approximate numeric data types?

0 Answers  

---

What is 3nf normalization form?

0 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers  

---

What are the security related catalog views? : sql server security

0 Answers  

---