Answer Posted / neeraj sharma

When we fire the trigger then the data goes to temporary
tables. when we execute insert, delete, update trigger the
the data goes to temporary tables. these temporary tables
are called as magic tables. There to types of magic tables:
1. Inserted
2. Updated

What are the types of indexing?

600

---

Explain identity in sql server?

569

---

After removing a table from database, what other related objects have to be dropped explicitly?

560

---

How to provide default values to function parameters?

605

---

How do I shrink an ldf file?

572

---

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

501

---

what is the system function to get the current user's user id? : Sql server database administration

559

---

Which joins are sql server default?

513

---

Write the SQL query to drop, truncate and delete table.

554

---

How do you size a resultset?

504

---

What is indexing in sql server with example?

525

---

What is lock escalation and what is its purpose?

559

---

What is sql server used for?

558

---

How can I create a new template for import ? : sql server management studio

603

---

how to invoke a trigger on demand? : Sql server database administration

567

---