Conclusion
In this chapter, you have seen how to create user-defined functions. First, you saw the syntax for creating such functions. Next, the differences between scalar and tabular functions were covered. A scalar function returns a single value, whereas a tabular function returns multiple values using the TABLE data type. Next, the multistatement and in-line tabular functions were discussed. After the creation and definition of the different types of user-defined functions, you saw how to call these types of functions. Last, the determinism of functions was covered. The addition of user-defined functions to SQL Server should make it easier for you to create powerful applications.