ShowScalarFunctions

Table of Contents



Lists the built-in scalar functions with their parameters and descriptions.

ShowScalarFunctions()

Name, ReturnType, Parameters and Description. Each prototype is also returned as a message.

round-pushpin Lists the scalar functions.
EXEC ShowScalarFunctions




SQL :: Guid
Returns a new random globally unique identifier.
SQL :: IfNull
Returns the given value, or the default value when the given value is null.
SQL :: IfNullNumeric
Returns the given number, or the default number when the given value is null.
SQL :: IIF
Short for "immediate if": returns whenTrue when the condition is true and whenFalse otherwise. The condition is usually one of the boolean functions such as IsEqual or IsGreater.
SQL :: IndexOf
Returns the zero-based position of the first occurrence of textToFind in textToSearch, starting the search at offset. Returns -1 when it is not found.
SQL :: IsBetween
Returns true (1) if the value is within the given range, including the range boundaries.
SQL :: IsDouble
Returns true (1) if the given value can be converted to a decimal number.
SQL :: IsEmpty
Returns true (1) if the given value is null or an empty string.
SQL :: IsEqual
Returns true (1) if the two given values are equal. The comparison is case-sensitive.
SQL :: IsGreater
Returns true (1) if the first value is greater than the second.