What is Difference between Stored Procedure and Function in SQL Server

• 举报此文章

Brijesh Prajapati

Brijesh Prajapati

Azure Data Engineer | ADF | Azure DataBricks | ADLS | Azure SQL | Synapse Analytics | Cosmos DB #dataengineer

发布日期: 2016年7月29日

+ 关注

Stored Procedures:Stored Procedures is pre-compile objects which are compiled for first time and its compiled format is saved which executes (compiled code) whenever it is called.

Function:Function is not pre-compiled object it will execute every time whenever it was called.

要查看或添加评论，请登录

Brijesh Prajapati的更多文章

• Find missing id in SQL Server without loop.

  2019年3月30日

  Find missing id in SQL Server without loop.

  Find missing id in SQL Server without loop. OUTPUT:

  4
• What is null in SQL Server ?

  2016年11月29日

  What is null in SQL Server ?

  Answer : Null is a undefined data in SQL-Server.

  5

  1 条评论
• Difference between CTE(Common Table Expressions) and Temp Table in SQL Server

  2016年10月14日

  Difference between CTE(Common Table Expressions) and Temp Table in SQL Server

  Difference between CTE(Common Table Expressions) and #Temp Table in SQL Server

  9

  1 条评论
• Difference between CTE(Common Table Expressions) and Table Variable in SQL Server

  2016年10月10日

  Difference between CTE(Common Table Expressions) and Table Variable in SQL Server

  Difference between CTE(Common Table Expressions) and Table Variable in SQL Server : https://blog.ithubcity.

  10

  1 条评论
• SQL SERVER- Script to find or get all indexes on table with columns name in the database

  2016年9月14日

  SQL SERVER- Script to find or get all indexes on table with columns name in the database

  In this article i am goint to explain write a Scrits to find all the indexes that have included columns in it and the…

  4
• SQL SERVER - write a query to find all tables in a Database that have a specific column name

  2016年9月1日

  SQL SERVER - write a query to find all tables in a Database that have a specific column name

  In this article i am goint to explain write a Scrits to find all tables in a db that have a specific column name. I…

  7
• Find row count all tables with size from Database in SQL SERVER

  2016年8月6日

  Find row count all tables with size from Database in SQL SERVER

  Find row count all table with size from database in SQL Server. Using sp_spaceused sp_spaceused without parameters…

  3
• What is Web Job in Azure

  2016年8月2日

  What is Web Job in Azure

  What is Web Job in Azure Web Role is a Cloud Service role in Azure that is configured and customized to run web…

• What is Common Table Expression (CTE) in SQL SERVER

  2016年7月29日

  What is Common Table Expression (CTE) in SQL SERVER

  CTE stands for Common Table expressions. It was introduced with SQL Server 2005.

  2
• MVC TempData – Peek vs Keep

  2016年7月27日

  MVC TempData – Peek vs Keep

  Most of the MVC developer knows that TempData is used to preserve data for a single request but reality is that…

  1

Show more

See all articles