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
How to add a check box or a dropdown list to a column in a datagrid?
What is sqldatasource?
What is bubbled event can you please explain?
Is ado.net dead?
How to retrieve the user id which is provided while windows authentication?
How can we serialize the dataset object?
What is the use of ADO.NET and XML web services?
What is partial class?
What is two way data binding android?
What are the different ado.net namespaces?
Explain sqlconnection object?
What is ado connection?
What is the difference in record set and dataset?
differences between ADO and ADO.NET
What is the difference between the clone() and copy() methods of the dataset class?