Answer Posted / debasis

select count(*) from <tablename> returns the number of rows
in the table.

select count(col_name) from <tablename> return number
values in the column (Ignores null value in the colum). For
example if we execute the following 2 queries then

select count(*) form emp
select count(comm) form emp

The result will be
14
4

How many triggers you can have on a table?

1032

---

What are the three different part of rdl file explain them?

274

---

What is 'write-ahead log' in sql server 2000 ?

1105

---

What is the data type of time?

1014

---

What are window functions in sql server?

1065

---

What is the purpose of optimization?

1055

---

Do you know what is a linked server in sql server?

1067

---

What is named query? : sql server analysis services, ssas

998

---

what happens on checkpoint? : Sql server database administration

1156

---

Can a table have 2 primary keys?

1030

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1110

---

What are unicode character string data types in ms sql server?

1338

---

Tell me what is the stuff and how does it differ from the replace function?

1032

---

What are the 7 disadvantages to a manual system?

1029

---

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1990

---