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

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

---

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

How and why use sql server?

0 Answers  

---

What is sql server schema compare? How we can compare two database schemas?

0 Answers  

---

Do you know what is blocking?

0 Answers  

---

What is a virtual table in sql?

0 Answers  

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---

Write a sql query to get zero records from a table having n number of records?

0 Answers   TCS,

---

What it means to be triggered?

0 Answers  

---

What is the default sql server instance name?

0 Answers  

---

How can I enforce to use particular index?

1 Answers   Symphony,

---