Want to know what functions are available in your database but don’t want to go through the pain of searching help.. well you can actually look for it right in SQL Server management studio. Connect to your database. Expand programmability -> Functions -> System Functions. This lists out all the available system functions. A pretty descriptive tooltip is also available.