Answer Posted / sivashankar.soma

The INSERTED and DELETED tables, popularly known as MAGIC
TABLES.

How to delete existing triggers using "drop trigger"?

552

---

explain different types of joins? : Sql server database administration

521

---

What are the differences between union, intersect, and minus operators?

562

---

Can you explain about buffer cash and log cache in sql server?

492

---

How do you send email on SQL Server?

568

---

---

Is it possible in sql table to have more than one foreign key?

600

---

When would you use a before or after trigger?

484

---

Explain Reporting Life Cycle?

90

---

What is mapping schema?

565

---

What is the maximum size of column in sql server?

501

---

What happens if ntwdblib.dll is missing on your machine?

626

---

How is sql used in sql server?

493

---

What is the use of sign function?

549

---

Define synonym?

724

---

How to create a stored procedure with a statement block in ms sql server?

568

---