Differences between functions and stored procedures?

Answer Posted / purushotam bhardwaj

FUnction use when you want to return any value only
but SP is best for all

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about extended stored procedure?

673


What is replace and stuff function in sql server?

732


What are the advantages of user defined function?

661


How to connect a database with sql express.?

750


what's new in sql server 2016?

725






Is candidate a key?

711


What is row-level compre?

713


Define tempdb database?

751


What is the difference between function and stored procedure in sql server?

679


What is the importance of three tier architecture?

813


What is resource governor?

718


What is the default sql server instance name?

750


What is query processing?

692


How to find out what is the default collation in a database?

789


What is the use of for clause?

768