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


Please Help Members By Posting Answers For Below Questions

What are the advantages dts has over bcp?

739


What is forward - only cursors / read only cursor?

724


What stored by the model?

719


How many instances per computer are there in sql server 2000?

769


Why we use trigger in sql server with example?

708


Explain primary key, foreign key and unique key?

747


what are the important architecture components of SSRS?

112


What is database black box testing?

775


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

791


Can we use custom code in ssrs?

782


What is sql language?

720


Explain can you implement data mining in ssrs?

122


What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

744


What is bcp? When does it use?

676


How to download and install microsoft .net framework version 2.0?

752