Differnce between Stored procedure and user defined functions?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is acid in ado.net?

604


What are three methods for displaying data in a syncfusion datagrid

699


What is the difference between dataset and datatable?

569


Which object is used to add relationship between two Datatables?

658


Describe datareader object of ado.net with example.

594






What is the use of sqldatareader class?

554


What is the difference between executequery and executenonquery?

592


What is the current version of entity framework?

572


What are the different methods by which we can populate a dataset?

796


What does ole stand for in excel?

717


What is ole db and odbc?

589


What is commandbuilder in ado.net?

602


How can I retrieve two tables of data at a time by using data reader?

596


What is the difference between Dataset. clone and Dataset.copy?

640


What is the difference between typed and untyped dataset?

590