ShowScalarFunctions
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.
EXEC ShowScalarFunctionsSQL :: ShowTransactions
Shows every active transaction, optionally for a single process.
SQL :: ShowVersion
Shows the names and versions of the engine's assemblies, or of every loaded assembly when showAll is true.
SQL :: ShowWaitingLocks
Shows the processes that are currently blocked waiting for a lock, optionally for a single process.
SQL :: Sleep
Pauses the executing query for the given number of milliseconds. Useful for testing locking and timeouts.
SQL :: SubString
Returns length characters of the value, starting at the zero-based startIndex.
SQL :: Syntax
Basic KBSQL syntax and some examples.
SQL :: System Procedures
Built-in procedures for inspecting and managing the database engine.
SQL :: Terminate
Terminates a process: rolls back its transaction, disconnects it and frees its resources. Kill does the same thing.
SQL :: ToLower
Returns the value converted to lower case.
SQL :: ToNumeric
Returns the value converted to a number.