Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 28662 Views
- Microsoft, Symphony, I also Faced
- E-Mail Answers
Answer Posted / sharad kulat
Store Procedure Is first tme complie and make the
Execution plan & next time proc just call plan .so its get
execute fast.In case Function compile every request.
function & Store procedure return not only single but also
number of value .
function return number of value useing return type table.
You Can use Function with select ,case Statement ,same
thing can not do through Store procedure.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Which parameter of ConnectionString is used to specify the name of the database?
How do I delete a row from a DataTable?
What Is Difference Between Ado And Ado.net?
What is ado.net full form?
describe the dataset object in ado.net.
What are all the classes that are available in System.Data Namespace?
What is the full form of ado?
What are the uses of Stored Procedure?
How to add an aggregate column?
What is bubbled event?
What is dataadapter in ado.net?
What is difference between Dataview and Datatable?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
What is the hierarchy of data in databases?
How to aggregating data across related tables?
