Answer Posted / amit bhardwaj

SELECT COUNT(colmnName) FROM Tablename GROUP BY Columnname

How is sql used in sql server?

997

---

System requirements for sql server 2005 express edition?

1001

---

how many no of arguments can be passed in procedures and functions

5541

---

How to rename an existing column with sql server management studio?

989

---

What are difference between Cluster index and Non-Cluster index?

1064

---

What are various aggregate functions that are available?

971

---

How can we migrate from SQL server to SQL Azure?

113

---

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

943

---

What is temporal table?

879

---

List some major differences between triggers and stored procedures?

899

---

Does the unique constraint create an index?

1047

---

What is the return type of executeupdate ()?

896

---

How do I save a stored procedure in sql server?

985

---

How to find out what is the default collation in a database?

1111

---

What is the fillfactor concept in indexes?

972

---