1)sp are pre comiled so while execution time it save time 2)sp returns ma

Differnce between Stored procedure and user defined functions?

Question Posted / suraj

Answer Posted / suraj

1)sp are pre comiled so while execution time it save time
2)sp returns many values where as function return only one
value

Is This Answer Correct ?

10 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the difference between readonly vs. Const?

1005

Give few examples of datareader that is used in different dataproviders.

968

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

963

Where is adodb dll located?

961

What are the ado.net objects?

937

Explain the dataadapter class in ado.net?

1202

Does ado.net use odbc?

942

What is a string variable?

910

What is ado.net tutorial?

922

What do you know about ADO.NET's objects and methods?

968

Give an example that shows how to execute a stored procedure in ado.net?

1063

Which is faster sqldataadapter and sqldatareader?

909

What is a data control clerk?

1037

Do you use stored procedure in ado.net?

1021

What are the benefits of using of ADO.NET in .NET 4.0?

1063