✏️ Explanatory Question

Benefits of Function in SQL Server

👁 444 Views
📘 Detailed Answer
💡

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.