Answer / raju

Having clause is applied only to the group by function
where as where clause is applued to each and every row in a
table

Answer / dhiman

Where clause is used to check for the condition- select rows
& restrict rows and where comes before having clause whereas
Having is clause that is created to utilize all the group
functions (sum,avg,min,max,count) and is used for select or
restrict a particular group.

Answer / anil sharma

Having clause ia used only with group by, and where used with any input type

List the various tools available for performance tuning?

0 Answers  

---

What is the significance of master, tempdb and model databases?

0 Answers  

---

What is a file group?

0 Answers  

---

What are the different authentication modes in sql server?

0 Answers  

---

is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

---

Explain primary key?

0 Answers  

---

ow to bring suspect mode datbase online from scratch

0 Answers  

---

Explain the steps to create and execute a user-defined function in the 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 sql server 2000 work load governor?

0 Answers  

---

How many triggers you can have on a table?

0 Answers  

---

How can I create a table from another table without copying any values from the old table?

3 Answers  

---