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 are different backups available in sql server?

598

---

Difference between report and query parameter.

590

---

What is store procedure? When do you use?

517

---

What is a virtual table in sql?

543

---

What program is used to store the data source file?

497

---

---

Explain user defined views?

566

---

Why use “pivot” in sql server?

614

---

What is field with example?

507

---

How can you insert values in multiple rows using one Insert statement?

608

---

How to copy data from one table to another table?

535

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

506

---

How to write character string constants or literals in ms sql server?

532

---

Which are the third-party tools used in sql server and why would you use them?

487

---

Do I need a report server to run reports in my application?

104

---

What is extended stored procedures?

554

---