Answer Posted / yoshita kundwani

Cursors can be considers as named result sets which allow a
user to move through each record one by one.

Explain temporary table vs table variable by using cursor alternative?

530

---

Can we use where clause in union?

603

---

What is the purpose of self join?

511

---

How can you fetch alternate records from a table?

555

---

What is the difference in accessing db between sql server vs sql azure?

157

---

---

How to convert numeric expression data types by assignment operations?

529

---

Explain what is cte (common table expression)?

638

---

Tell me extended events in sql server 2008?

567

---

what are isolation levels? : Sql server database administration

503

---

How to maintain a fill factor in existing indexes?

535

---

Why use triggers?

582

---

How sql server enhances scalability of the database system?

596

---

Determine how to use the inserted and deleted pseudo tables?

552

---

What does sql server mean?

538

---

What is 2nf example?

558

---