What is difference between a PROCEDURE & FUNCTION ?
Answer Posted / surajit pathak
We can use in,inout,out parameters in functions also.
The most important difference is we can use functions in
normal sql queries if it is not containing any out
parameters.
but we cann't use procedures in sql queries....
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How many times can we commit in a loop?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is a database event trigger?
What is meant by temporal data?
How do you update a value in sql?
When should I use nosql database?
What does the file extension accdb stand for?
Why is the cursor important?
What is a dynamic query?
Which normal form is best?
What is the difference between clustered and non-clustered index in sql?
What is sql rowcount?
What are the two types of cursors in pl sql?
what are the disadvantages of mysql? : Sql dba
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????