Answer Posted / khaleek.ahmad

9.There is possible of recursive function like
max(min(something)),but there is nothing like in procedure.

10.We can call a function from a procedure, but it is not
possible to call a procedure from a function

For more detail , please see at.
http://interview-preparation-for-you.blogspot.com/2010/05/difference-between-function-and.html

What happens if you are trying to access a schema not owned by you?

923

---

Can you please differentiate between a primary key and a unique key?

966

---

How to scale out a federation by Sql statement?

116

---

What is meant by Active-Passive and Active-Active clustering setup?

1089

---

How to integrate the ssrs reports in application?

943

---

Name 3 ways to get an accurate count of the number of records in a table?

981

---

What is used to replicate sessions between instances in coldfusion clusters?

1023

---

Explain what are various ways to enhance the ssrs report?

1000

---

What is the meaning of resultset type_scroll_insensitive?

919

---

Explain about Normalization?

1019

---

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

891

---

What is the difference between set and select?

1027

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

922

---

What are horizontal and vertical scaling?

170

---

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

117

---