Home / Questions / Benefits of Function in SQL Server
Explanatory Question

Benefits of Function in SQL Server

👁 444 Views
📘 Detailed Answer
🕒 Easy to Read
Read the answer carefully and go through the related questions on the right side to improve your understanding of this topic.

Answer with Explanation

  • Modular Programming: Functions allow modular programming where it is generated once and called multiple times during programming.
  • Faster Execution: Every time a function is called, the execution code is saved in the cache that helps in faster execution of function when it is called again.
  • Reduced Network Traffic: A function utilizes the WHERE clause for reducing the overall size of the code that ultimately results in enhanced network performance.