What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

---

What are the different types of join?

0 Answers  

---

What is the use of builtinadministrators group in sql server? : sql server security

0 Answers  

---

Write a sql query to get zero records from a table having n number of records?

0 Answers   TCS,

---

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

---

What happens if the update subquery returns no rows in ms sql server?

0 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

---

What are tables in sql server?

0 Answers  

---

What are different types of statements that are supported by sql?

0 Answers  

---

What method is used by the Command classes to execute SQL statements that return single values?

0 Answers   B-Ways TecnoSoft,

---