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 is ado.net tutorial?

948

What do you mean by ‘batch updates’?

1045

What is a non query?

932

Define Execute Reader?

1069

What are the parameters that control most of connection pooling behaviors?

1011

What is a dynaset in access?

1063

What is defaultview in datatable?

1029

What are the steps you will take to improve performance?

895

What does sqldatareader return?

965

What does executenonquery () method return?

938

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

1110

Describe the disconnected architecture of ADO.NET’s data access model.

1063

What is oledb driver?

936

What is difference between dataset and datatable?

1178

What is the default Timeout for SqlCommand.CommandTimeout property?

1016