How to count rows with the count(*) function in ms sql server?

0 Answers  

---

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

2 Answers   Apollo,

---

how to find the second salary?

10 Answers   HCL, Prithvi,

---

What happens if strings are casted into wrong code pages in ms sql server?

0 Answers  

---

When do you use SQL Profiler?

3 Answers   Wipro,

---

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 Answers  

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

0 Answers  

---

What is an expression in ms sql server?

0 Answers  

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,

---

What is delete query?

0 Answers  

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

The Difference between 'Count' and 'Count(*)'

13 Answers  

---