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

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1416


How is table type constraint applied to a table?

733


What is the purpose of grouping data in a report?

720


What are the differences between decimal and float in ms sql server?

751


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

780






How do I determine how many instances of sql server are installed on a computer?

714


What is collation?

880


How to create new tables with "select ... Into" statements in ms sql server?

681


How to use column default values in insert statements in ms sql server?

718


Why I am getting this error when renaming a database in ms sql server?

731


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

668


Some queries related to SQL

738


What is store procedure? When do you use?

687


what is the Ticketing tool used in Wipro technologies at Bangalore...???

7811


What do you understand by a stored procedure?

784