Answer / kumar.t

1. Stored Procedure to return the output parameter.
but function only return single values no output
parameter.

2. Select Clause we cann't use stored procdure. but
fucntion we can use.

3. XMl Clause contain we can use stored procdure. but
function we cann't use.

4. Whenever to execute function at present any error in the
function automatically to exit from the function. but
stored procudure to ignore the error then go to next line.

By
Kumar.T

Answer / samant

1.For user defined function one must have to specify it's
return type while in stored procedure it is not mandatory.

2. u can use function in expression but not stored
procedures

How to rebuild all indexes on a single table?

0 Answers  

---

What is unique key constraint?

0 Answers  

---

How can you hide the sql server instances?

0 Answers  

---

How does index makes search faster?

0 Answers   QuestPond,

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

Define self join in sql server joins?

0 Answers  

---

Explain the advantages of merge replication?

0 Answers  

---

Normalization and denormalization

3 Answers   Wipro,

---

How do I view a trc file?

0 Answers  

---

Explain throw statement in sql server 2008?

0 Answers  

---

whats the maximum size of view state??

0 Answers  

---

How to create hyperlink from returned sql query ?

0 Answers   MCN Solutions,

---