Function Vs Stored Procedure In SQL Server

Many times in interview one question commonly asked  that  what is Difference Between Stored Procedure and function, so by considering above requirement i have decided to write this blog to help Beginners and job seekers also who might be wants to know about it.
What is a Stored Procedure?
A Stored Procedure is a group of logical SQL statements to perform a specific task, such as insert, select, update and delete operations on a table and so on which is stored in a SQL database.
What is a function ?

Function is the logical group of SQL  statements which returns single value by performing the operation on group of SQL statements .it also stored in database.

I hope this blog is useful for all readers and these differences are enough to impress interviewer. If you have any suggestion then please contact me.

Post a Comment

Protected by Copyscape
Copyright © Compilemode