Differnce between Stored procedure and user defined functions?
Answer Posted / sivacharan svs
Funtion Should Return a value
Procedure may or may not return a value
Function can be used in Your Select Quries
Procedure has to be passed with or with out parameters
Select Getdate() as date
Function returns date time here
The resultant value of the stored procedure can be used in
application where as the resultant value of the stored
procedure is used in a query.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is difference between ado and other data object?
What is the use of adodc?
Explain how to find the given query is optimised one or not?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
What are the namespaces used in ado.net for data access?
What is a serialized object?
What are the benefits of ADO.NET?
What is difference between dataset and datatable?
What are three methods for displaying data in a syncfusion datagrid
Define isolation?
What is dbcontext and dbset in entity framework?
Can datareader hold data from multiple tables?
What are the major challenges in accessing data from a database?
What does ado stand for in ado.net?
What is the difference between Optimistic and Pessimistic locking?