Difference between stored procedure and function in sql server

• Function must return a value whereas Stored Procedure it is optional.
• Functions can have only input parameters for it whereas Procedures can have input/output parameters.
• Function takes one input parameter it is mandatory but Stored Procedure may take o to n input parameters.
•  Functions can be called from Procedure whereas Procedures cannot be called from Function.
• Procedure allows SELECT/INSERT/UPDATE/DELETE statement in it whereas Function allows  only SELECT statement in it.
• We can go for Transaction Management in Procedure whereas we can't go in Function.

Introduction to Object Oriented Programming Concepts (OOPS)

Class:

When you define a class, you define a blueprint for an object. This doesn't actually define any data, but it does define what the class name means, that is, what an object of the class will consist of and what operations can be performed on such an object.

Abstraction:

Data abstraction refers to, providing only essential information to the outside word and hiding their background details ie. to represent the needed information in program without presenting the details.
For example, a database system hides certain details of how data is stored and created and maintained. Similar way, C++ classes provides different methods to the outside world without giving internal detail about those methods and data.