This is a quick reference list of SQL Server advanced functions and how they are used to work with databases.

• SQL – SQL Server CAST() Function
  The SQL Server CAST() function converts a value of any type into a specified datatype.
• SQL – SQL Server COALESCE() Function
  The SQL Server COALESCE() function returns the first non-null value in a list.
• SQL – SQL Server CONVERT() Function
  The SQL Server CONVERT() function converts a value of any type into a specified datatype.
• SQL – SQL Server CURRENT_USER Function
  The SQL Server CURRENT_USER function returns the name of the current user in the SQL Server database.
• SQL – SQL Server IIF() Function
  The SQL Server IIF() function returns a value if a condition is TRUE, or another value if a condition is FALSE.
• SQL – SQL Server ISNULL() Function
  The SQL Server ISNULL() function returns a specified value if the expression is NULL, and the expression itself if the expression is NOT NULL.
• SQL – SQL Server ISNUMERIC() Function
  The SQL Server ISNUMERIC() function tests whether an expression is numeric, and returns 1 if the expression is numeric and 0 if it is not numeric.
• SQL – SQL Server NULLIF() Function
  The SQL Server NULLIF() function returns NULL if two expressions are equal, or returns the first expression if they are not equal.
• SQL – SQL Server SESSION_USER Function
  The SQL Server SESSION_USER function returns the name of the current user in the SQL Server database.
• SQL – SQL Server SESSIONPROPERTY() Function
  The SQL Server SESSIONPROPERTY() function returns the session settings for a specified option.
• SQL – SQL Server SYSTEM_USER Function
  The SQL Server SYSTEM_USER function returns the login name for the current user.
• SQL – SQL Server USER_NAME() Function
  The SQL Server USER_NAME() function returns the database username based on the specified id.