Answer Posted / amit bhardwaj

SELECT COUNT(colmnName) FROM Tablename GROUP BY Columnname

How does clustered and non clustered index work?

925

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

985

---

How do I find my localdb version?

987

---

Can primary key be null?

933

---

How do I find the sql server version?

1027

---

Differentiate between truncate vs delete in mssql?

1085

---

What is a cursor, index in sql?

1072

---

How do I start sql server?

978

---

How do I install sql server?

893

---

Why transaction is important?

976

---

How to include date and time values in sql statements?

1086

---

How to download and install the scaled-down database adventureworkslt?

992

---

Is sql server a database?

1000

---

What is the server name in sql server?

1011

---

where the connection string store in the database

2072

---