Join Martin Guidry for an in-depth discussion in this video Why use functions?, part of SQL Server: Triggers Stored Procedures and 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.…Well, if you have customers from dozens of different countries that all need…
- Comparing triggers, functions, and stored procedures
- Installing and configuring SQL Server
- Creating a stored procedure
- Returning data using data sets
- Creating user-defined functions
- Using "after," "instead," and nested triggers
- Modifying existing stored procedures
- Implementing logging on DELETE
- Choosing between T-SQL and CLR
- Executing a stored procedure
- Passing parameters
Skill Level Advanced
1. Getting Started
2. Installing SQL Server
Configuring your environment4m 53s
3. Stored Procedures
4. User-Defined Functions
6. Putting It All Together
7. Using CLR Assemblies
8. Exploring an ASP.NET Web Application
Next steps1m 43s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.