What is difference between stored procedure and function?

Answer Posted / rakesh

mojor difference is
function must return a value but a
procedure may or may not return a value

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is precedence constraint?

538


what are candidate key, alternate key and composite key? : Sql server database administration

491


What triggers long term care?

552


How do I edit a stored procedure in sql server?

500


Is oracle faster than sql server?

549






What are the different types of backups avaialabe in sql server 2005?

616


what is datawarehouse?

643


How to truncate the log in sql server 2012? : sql server database administration

565


How do I start sql server 2017?

523


Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

552


How to find Duplicate Records In table?

579


Tell me the difference between clustered and non-clustered index?

503


Indexes are updated automatically is the full-text index also updated automatically?

619


What do you mean by stored techniques? How would we use it?

572


what's the information that can be stored inside a bit column? : Sql server database administration

523