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 :: Print
Evaluates an expression and returns the result as a message with the query results.
SQL :: RefreshMyRoles
Reloads the role memberships of the logged in account. Roles are cached at login, so run this after your memberships change instead of logging out and back in. The roles are returned as messages.
SQL :: ReleaseCacheAllocations
Returns unused cache memory to the operating system. Call ClearCacheAllocations first to release as much memory as possible.
SQL :: Right
Returns the given number of characters from the end of the value.
SQL :: Round
Rounds a number to the given number of decimal places. Midpoint values are rounded to the nearest even number (2.5 rounds to 2).
SQL :: Scalar Functions
Scalar functions are evaluated once per row.
SQL :: Sha1
Returns the SHA-1 hash of the value's UTF-8 bytes as a lower case hex string.
SQL :: Sha256
Returns the SHA-256 hash of the value's UTF-8 bytes as a lower case hex string.
SQL :: Sha512
Returns the SHA-512 hash of the value's UTF-8 bytes as a lower case hex string.
SQL :: ShowAggregateFunctions
Lists the built-in aggregate functions with their parameters and descriptions.