Exec

Table of Contents



The EXEC directive is used to execute a stored procedure whther it be built-in or user created.


round-pushpin Executes the built-in ShowCachePartitions procedure to show the memory cache partitions.
exec ShowCachePartitions

round-pushpin Executes a user defined stored procedure passing it a parameter.
EXEC WordList:Word:CreateAndGetWord('Katzebase')




SQL :: ShowLocks
Shows all locks for all transactions.
SQL :: ShowMemoryUtilization
Shows the operating system level memory utilization used by the database engine.
SQL :: ShowProcesses
Shows all active processes, their session ID, process ID and various transaction information.
SQL :: ShowTransactions
Shows all transactions that are current active.
SQL :: ShowVersion
Shows the names and versions of all loaded assemblies.
SQL :: ShowWaitingLocks
Shows processes that are currently waiting on locks.
SQL::Keywords
A breakdown of all high-level statements available via the query handler.
SQL::ShowAggregateFunctions
Displays the list of built-in aggregation functions and their parameters.
SQL::ShowCachePages
Displays information about cached database pages.
SQL::ShowScalarFunctions
Displays the list of built-in scaler functions and their parameters.