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 to insert new line characters into strings?

932

---

How many categories of functions based their return modes?

1061

---

How to generate create view script on an existing view?

944

---

Introduction of rollup clause using sum and group by clause?

898

---

explain databases and sql server databases architecture? : Sql server database administration

908

---

What is the main purpose of having conversation group?

846

---

Do you know what is a linked server in sql server?

964

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

904

---

What do you do in data exploration

927

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

850

---

What the different types of Replication and why are they used?

977

---

Why variables called the most powerful component of ssis?

1025

---

What is the order by used for?

965

---

Is ssrs support other database except ms sql server?

127

---

What is @@error in sql?

1020

---