Differnce between Stored procedure and user defined functions?
- 17 Answers
- 23805 Views
- Microsoft, Symphony, I also Faced
- E-Mail Answers
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 are the data providers in ADO.NET framework?
What is a datagridview?
What do you know about ADO.NET's objects and methods?
What are the advantages of oledb compared with other classes?
What is DataReader Object?
What is the executescalar method?
What is the hierarchy of data in databases?
How to add a check box or a dropdown list to a column in a datagrid?
Explain the role of data provider in ado.net?
What is the default Timeout for SqlCommand.CommandTimeout property?
What does ado stand for?
Define bubbled event?
What is dataset object? Explain the various objects in dataset.
Define table relations?
Which control of the BindingNavigator returns the current position within the data source?
