Answer Posted / mythili

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

SQL Server Architecture ?

2462

---

What are the different methods available under sqlcommand class to access the data?

1127

---

What is cube dimension? : sql server analysis services, ssas

1014

---

What is difference between equi join and natural join?

1045

---

How the authentication mode can be changed?

1137

---

How to create a simple stored procedure in ms sql server?

1035

---

What is sql server english query?

1136

---

What is difference between unique and primary key?

918

---

What have included columns when we talk about sql server indexing?

1039

---

How to start sql server browser service?

1141

---

Does partitioning improve performance sql server?

985

---

Explain the working of sql privileges?

1097

---

Explain can SSRS reports Cache results?

160

---

Is it ok to shrink transaction log?

1008

---

What is self contained sub query?

1065

---