Benefits of Function in SQL Server

SQL >   SQL Functions >   Functions Introduction  

Long Question

404


Answer:

  • 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.


This Particular section is dedicated to Question & Answer only. If you want learn more about SQL. Then you can visit below links to get more depth on this subject.




Join Our telegram group to ask Questions

Click below button to join our groups.