MS SQL ServerBackEnd Programming MS SQL Server SQL 

Stored Procedure Vs Function in MS SQL Server

Stored Procedure: A set of SQL Queries which are used to perform a specific task. A stored procedure can improve the performance of a database.

Function: A  set of SQL Queries which can be used to pass parameters into and return values from it.


Sl.No Stored Procedure Function
1 Compiled only once Complies every time the function is invoked
2 Input and Output Parameters are permitted Only input parameters are permitted
3 Need not necessarily return a value A return value is necessary
4  A Function can be invoked by a Stored Procedure  A Stored Procedure cannot be invoked by a Function
5  SELECT,INSERT, UPDATE, DELETE cannot call a Stored Procedure  SELECT,INSERT, UPDATE, DELETE can call a Function


Backend developer, Works on C#, SQL server lives in Manipal, Karnataka, India.

Also Read:  Integration sendinblue Transactional Email using Python

Related posts