ShowScalarFunctions

Table of Contents

Overview
Prototype
Returns

Example

See also
Related

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.

Lists the scalar functions.

EXEC ShowScalarFunctions

The home page

Returns the absolute value of a number.

SQL :: Alter Procedure

User-defined stored procedures are not currently available.

Cancels (rolls back) the transaction of the given process, leaving the process connected.

Returns the smallest whole number that is greater than or equal to the given number.

SQL :: CheckpointHealthCounters

Writes the health counters to disk. This is useful when monitoring performance and you need the metrics in the health JSON file.

SQL :: Checksum

Returns a simple 16-bit checksum (0 to 65535) of the value's ASCII bytes. It is fast but not collision resistant; use Sha256 when the value must be unique.

SQL :: ClearCacheAllocations

Empties the engine's memory cache. The memory is kept allocated for future cache use; call ReleaseCacheAllocations afterwards to return it to the operating system.

SQL :: ClearHealthCounters

Resets the health counters tracked by the engine. This is helpful when performance tuning.

SQL :: Coalesce

Returns the first of the given values that is not null. Accepts any number of values.