Why use functions? SQL Server


show more Why use functions? provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions show less
please wait ...

Why use functions?

Now let's talk about some of the advantages of using functions. Functions have most of the same benefits of stored procedures. They can simplify administration and maintenance of common routines. The code is stored with the data. They do have some of the same security options as stored procedures, but people don't use these quite as commonly as they do with stored procedures. And we also have all of the performance improvements of the stored execution plan. Additionally, functions have some other benefits.

In line functions can be very easy and intuitive. A developer who is familiar with select statements can quickly adapt to a select statement written with functions rather than with typical database objects. It's just not that big of a jump to go from a mindset of not using functions to a mindset of using functions, because the code is still structured so similarly. Functions can also be a quick way to abstract some complex ideas. So something like formatting an address. Wel...

Why use functions?
Video duration: 1m 27s 1h 52m Advanced

Viewers:

Why use functions? provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...