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
What are the different Topologies in which Replication can be configured?
what stored procedure can you use to display the current processes? : Sql server administration
Explain intellisense for query editing
Can a synonym name of a table be used instead of a table name in a select statement?
What is a coalesce function?
What is the maximum size of sql server database?
What is analysis service repository?
What is default constraint?
What is efficiency data?
What is compound operators?
How to access the inserted record of an event?
When cursors are useful?
Explain linked server in sql?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
How you can get a list of all the table constraints in a database?