Differnce between Stored procedure and user defined functions?
- 17 Answers
- 23735 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 is aggregate root?
Define atomicity?
What is ado recordset?
How to identify the updated rows in a dataset?
What is difference between connected and disconnected architecture in ado.net?
How to load multiple tables into a dataset?
What is the role of the dataset object in ado.net?
What is difference between datagridview and datagrid control in winforms?
What is the difference between DataReader and DataSet in ADO.NET?
Is datareader faster than datatable?
Describe briefly an ADO.NET Dataset ?
What is difference between executequery and executeupdate?
Define Execute Scalar?
Why is it important to close an ado.net application?
What is the full form of ado.net?
