SQL, or Simple Query Language allows a limited type of expressions to be used within query. Apart from basic arithmetic, boolean and bitwise operators, many built-in functions can be used to form an expression.
Expressions should be used with caution, especially if resource-consuming functions are used.
More generally, SQL expression is defined as any type of SQL query that is evaluated (to a column, another query results etc) before the overall query is performed.
IPHost features:
MS SQL Monitoring
MS SQL Database Monitor is a simple IPHost Monitor. Use it to test connection to a MS SQL database server and run a SQL query. The first column of the dataset returned is interpreted as an integer value and used in performance checks …
ODBC Database Monitor
It allows to test connection to an ODBC database server and run a SQL query to interpret the results. The first column returned is treated as an integer value to be …
Oracle Database Monitor
It allows to test connection to an Oracle database server and run a SQL query. … Running certain SQL queries is a perfect means to test database used for …
