---
title: "What is different between Stored Procedure and Function in SQL server ?"  
description: "What is different between Stored Procedure and Function in SQL server ?"  
author: "Sanat Shukla"  
published: 2018-09-13  
canonical: https://answers.mindstick.com/qa/49793/what-is-different-between-stored-procedure-and-function-in-sql-server  
category: "database"  
tags: ["mssql server", "sql", "mysql"]  
reading_time: 1 minute  

---

# What is different between Stored Procedure and Function in SQL server ?

[Stored Procedure](https://www.mindstick.com/articles/202/the-detailed-concept-of-stored-procedure-in-sql-server) and [Function](https://www.mindstick.com/articles/43970/purchase-suitable-wedding-dresses-for-your-wedding-function) in [SQL server](https://www.mindstick.com/articles/12343/sql-server-2017-ctp-2-0-now-available).


---

Original Source: https://answers.mindstick.com/qa/49793/what-is-different-between-stored-procedure-and-function-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.