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)

How do I find the port number for sql server?

973

---

What is the temp table?

929

---

Mention the differences between sql server and mysql.

1021

---

How much memory that we are using in Logshipping Concept?

1800

---

What authentication modes does sql server support?

1103

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1060

---

How to include text values in sql statements?

1045

---

What is bcp? When does it used?

983

---

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

1143

---

Which are the new data types introduced in sql server 2008?

887

---

Why use triggers?

1017

---

Explain the concept of recursive stored procedure.

965

---

What is the difference between index seek vs. Index scan?

1025

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

943

---

What are logical database components? : SQL Server Architecture

1044

---