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 connection string?
describe the dataset object in ado.net.
Give an example that shows how to execute a stored procedure in ado.net?
How can we perform transactions in .net?
What is ambient transaction?
What is the return type of executescalar?
What are different layers of ADO.Net?
Which keyword is used to accept variable number of parameters?
What does ado stand for?
how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....
What is ado.net and its features?
What is ole used for?
What is the executescalar method?
Which database is the ado.net?
What are the benefits of using of ADO.NET in .NET 4.0?