If you use SQL, then you already use built in functions such as SUM, COUNT and UPPER to transform data. By creating your own functions, you can execute complex code written in any host based language. This allows you to very easily reuse already tested business logic. This seminar will teach you what you need to know in order to create your own SQL functions.
Learning Objectives:
- Built in functions
- Anatomy of a function
- Steps required to build a function
- Creating and dropping functions
- Unpacking the create function statement