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.
Summary
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