Answer Posted / mythili

select BillDate, count(*) from AdminSalesDetailsItems group by BillDate

What is the difference between ‘having’ clause and a ‘where’ clause?

538

---

List the ways in which dynamic sql can be executed?

631

---

What is updatable resultset?

507

---

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

570

---

Who developed sql server?

520

---

---

What is an identity?

563

---

What is a unique index?

519

---

Define right outer join in sql server joins?

509

---

What is the openxml statement in sql server?

532

---

What is reference section?

491

---

What is sub query and its properties?

534

---

What is relationship? What number of sorts of relationship are there?

629

---

How to convert a numeric expression from one data type to another?

491

---

Explain how many normalization forms?

573

---

How does a profiler work?

509

---