Answer Posted / sivashankar.soma

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

How to defragment table indexes?

558

---

What is a trigger what are the advantages of trigger?

535

---

How can we migrate from SQL server to SQL Azure?

92

---

What is transactional replication?

565

---

How can you append an identity column to a temporary table?

453

---

---

Is natural join and equi join same?

536

---

Explain about Views?

610

---

What is the purpose of sql profiler in sql server?

519

---

What is trigger in salesforce?

504

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

541

---

What is the log shipping?

592

---

What is resource governor in sql server?

554

---

Explain what are the authentication modes in sql server?

504

---

What is the difference between coalesce() & isnull()?

538

---

What is data modeling and Reterminal integrity?

1496

---