User-defined funcions

 User-Defined Functions that allow you to define your own T-SQL functions that can accept zero or more parameters and return a single scalar data value or a table data type.

 2 types

1.Scaler UDF- when it executes, it gives you the single value

2.Table Valued UDF- when it executes, it gives you the result set (table)