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.

Do you know the isolation level that sql server support?

0 Answers  

---

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

---

When a primary key constraint is included in a table, what other constraints does this imply?

0 Answers  

---

Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,

---

What is the parse query button used for?

0 Answers  

---

What is a document index?

0 Answers  

---

Write a query to find 5th highest amount paid from the customer table.

0 Answers  

---

What is a group function explain with an example?

0 Answers  

---

Can you explain what is the use of custom fields in report?

0 Answers  

---

How do you identify a foreign key?

0 Answers  

---

What are Sql Reporting Services and analysis services? Can u Explain

1 Answers  

---

What is your recommendation for a query running very slow? : sql server database administration

0 Answers  

---