Answer Posted / amit bhardwaj

SELECT COUNT(colmnName) FROM Tablename GROUP BY Columnname

How the authentication mode can be changed?

1175

---

Why do we use stored procedures in sql server?

997

---

How connect excel to sql server?

1051

---

Do you know what are the ways available in sql server to execute sql statements?

1082

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1009

---

How do I port a number to sql server?

1095

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1097

---

What command do we use to rename a db, a table and a column?

978

---

what are the different stages of Report Processing?

141

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

952

---

tell me the disaster recovery plan

2559

---

How is SQL Azure different than SQL server?

225

---

Introduction of rollup clause using sum and group by clause?

1009

---

How to return the date part only from a sql server datetime datatype?

1162

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1115

---