Answer Posted / mythili

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

What is a derived table?

919

---

How do I find my localdb version?

976

---

What the different topologies in which replication can be configured?

1082

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1030

---

What is report snapshot in ssrs?

266

---

Can we write trigger for view?

998

---

What are the different acid properties?

1054

---

How can we determine what objects a user-defined function depends upon?

991

---

List the different normalization forms?

969

---

Explain the rules for designing files and file groups in sql server?

977

---

Do you know what is xpath?

1077

---

Can we hide the definition of a stored procedure from a use?

1214

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1048

---

How to insert new line characters into strings?

982

---

what is a self join? Explain it with an example? : Sql server database administration

938

---