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 will you know when statistics on a table are obsolete?

0 Answers  

---

What is the use of nvl work?

0 Answers  

---

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

---

Tell me what is the order in which the sql query is executed?

0 Answers  

---

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

---

---

Explain about remote stored procedure?

0 Answers  

---

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

How to delete existing rows in a table?

0 Answers  

---

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

---

What is an active database?

0 Answers   HCL,

---