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

In which files does sql server actually store data?

0 Answers  

---

Explain the advantages of merge replication?

0 Answers  

---

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  

---

what operator performs pattern matching?

2 Answers  

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

0 Answers  

---

what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

What are the properties of sub-query?

0 Answers  

---

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  

---

Which sql server is best?

0 Answers  

---

What does set rowcount do?

0 Answers  

---

What is a with(nolock)?

0 Answers  

---

How to Rebuild Master database in sql server 2005.

2 Answers   Wipro,

---