difference between function and procedure
Answer Posted / ramya gurrala
Functions:1)Do calculations mostly.
2)Must return value.
3)Calling methods.
4)Function can stand alone.
Procedure:1)Do actions mostly.
2)May or may not return value(the return method is not same as function method).
3)Calling methods.
4)Procedure can not stand alone.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to find the list of fixed hard drive and free space on server?
Determine when to use stored procedure to complete sql server tasks?
Do you know how to store and query spatial data?
What is the difference between dbcc indexdefrag and dbcc reindex?
How does recursive cte works in sql server?
What are key constraints?
What is a Join and explain its types?
What does the on update no action do?
What do you mean by subquery?
How to create an index on a view?
Why is the need for data conversion transformations?
What is the difference between for xml raw and for xml auto?
What is function of master database?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
How to apply cascading referential integrity in place of triggers?