Answer Posted / ambi

select BillDate, count(*) [Total] from
AdminSalesDetailsItems group
by convert(varchar(50),BillDate,101)

select BillDate, count(*) [Total] from
AdminSalesDetailsItems group
by convert(varcharBillDate,101)

What command is used to create a database in the sql server and how?

1165

---

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

998

---

please differentiate between delete and truncate?

985

---

Is there any difference between primary key and unique with the not null condition?

936

---

Explain filestream storage of sql server 2008?

999

---

What is Extended user-defined?

947

---

How can I check if a view exists in a sql server database?

1024

---

what is blocking? : Sql server database administration

1019

---

What are the steps you will take to improve the performance of a poor performing query?

967

---

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

987

---

What are the different authentication modes in sql server? How can it be changed?

1072

---

Explain different types of locks in sql server.

1066

---

What happens if an integer is too big for int date type?

963

---

Is candidate a key?

940

---

What are different types of collation sensitivity?

980

---