SqlExpressionBuilder
Builder object for creating SQL expressions.
Functions
Compares value against any chained conditional expressions.
Returns the first of its arguments that is not null.
Checks if this expression is equal to some t value.
Checks if this expression is equal to some other expression.
Checks if this expression is equal to some other expression.
Checks if this expression is equals to single value returned from query.
Returns value evaluated at the row that is the first row of the window frame.
Checks if this expression is greater than some t value.
Checks if this expression is greater than some other expression.
Checks if this expression is greater than some other expression.
Checks if this expression is greater than or equal to some t value
Checks if this expression is greater than or equal to some other expression.
Checks if this expression is greater than or equal to some other expression
Checks if expressions from this Pair
are equal to elements from list. This syntax is unsupported by SQL Server.
Checks if expressions from this Triple
are equal to elements from list. This syntax is unsupported by SQL Server.
Checks if all columns in this List
are equal to any of the lists of values from list.
Checks if all columns in this List
are equal to any of the CompositeIDs from list.
Checks if this expression is equal to any element from list.
Checks if this expression is equals to any row returned from query.
Checks if this expression is not equal to some t value, with null
treated as a comparable value
Checks if this expression is not equal to some other expression.
Checks if this expression is not equal to some other expression, with null
treated as a comparable value
Checks if this expression is equal to some t value, with null
treated as a comparable value
Checks if this expression is equal to some other expression.
Checks if this expression is equal to some other expression, with null
treated as a comparable value
Returns true
if this string expression is null or empty, false
otherwise.
Returns value evaluated at the row that is offset rows before the current row within the partition; if there is no such row, instead returns defaultValue. Both offset and defaultValue are evaluated with respect to the current row.
Returns value evaluated at the row that is offset rows after the current row within the partition; if there is no such row, instead returns defaultValue. Both offset and defaultValue are evaluated with respect to the current row.
Checks if this expression is less than some t value.
Checks if this expression is less than some other expression.
Checks if this expression is less than some other expression.
Checks if this expression is less than or equal to some t value
Checks if this expression is less than or equal to some other expression.
Checks if this expression is less than or equal to some other expression
Checks if this expression matches the specified pattern.
Checks if this expression matches the specified expression.
Checks if this expression matches the specified pattern.
Calculates the remainder of dividing this expression by the t value.
Calculates the remainder of dividing this expression by the other expression.
Checks if this expression is not equal to some other value.
Checks if this expression is not equal to some other expression.
Checks if this expression is not equal to some other expression.
Checks if this expression is not equals to single value returned from query.
Checks if expressions from this Pair
are not equal to elements from list. This syntax is unsupported by SQL Server.
Checks if expressions from this Triple
are not equal to elements from list. This syntax is unsupported by SQL Server.
Checks if all columns in this List
are not equal to any of the lists of values from list.
Checks if all columns in this List
are not equal to any of the CompositeIDs from list.
Checks if this expression is not equal to any element from list.
Checks if this expression is not equals to any row returned from query.
Checks if this expression is not equal to any element from the column of table with only a single column.
Checks if this expression doesn't match the specified pattern.
Checks if this expression doesn't match the specified pattern.
Checks if this expression doesn't match the specified expression.
Returns value evaluated at the row that is the n'th row of the window frame (counting from 1); null if no such row.
Returns an integer ranging from 1 to the numBuckets, dividing the partition as equally as possible.
Returns the relative rank of the current row, that is (rank - 1) / (total partition rows - 1). The value thus ranges from 0 to 1 inclusive.
Calculates the remainder of dividing this expression by the t value.
Calculates the remainder of dividing this expression by the other expression.