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

Explain ado.net features?

987

How do you connect to sql server database without using sqlclient?

1039

Which object needs to be closed?

2193

How to store data in memory?

889

Give an example of a .net application which connects to microsoft access database using ado.net classes.

1076

Explain how do you connect to sql server database without using sqlclient?

941

What is the use of Dataview?

1064

What is difference between entity framework and ado.net?

881

Which is faster datareader or dataadapter?

934

What are ado.net objects?

1009

Define isolation?

919

If we are not returning any records from the database, which method is to be used?

1273

What is command class in ado.net?

936

What is ado recordset?

921

Explain what is datagrid with an example?

1033