Differnce between Stored procedure and user defined functions?
- 17 Answers
- 23767 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
Define bubbled event?
What is the difference between ado.net and oledb?
What is XML serialization
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
What are the different methods by which we can populate a dataset?
What is the default Timeout for SqlCommand.CommandTimeout property?
What are the several execute methods of ado.net?
Explain which name space is used to get assembly details?
Explain how to find the given query is optimised one or not?
What is data control techniques?
What are the differences between OLEDB and SQLClient Providers?
What are the core objects of ADO.NET?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
Explain ado.net features? Benefits? Drawbacks?
Where is adodb dll located?
