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.