The resulting row hash value is typed BYTE(4).
IF the argument list is … | THEN HASHROW … |
---|---|
empty | returns the maximum hash code value. |
an expression that evaluates to NULL | returns '00000000'XB. |
a list of expressions where all the expressions evaluate to NULL | |
an expression that evaluates to 0, '', ' ', or a similar value | |
a valid, non-NULL expression that can appear in the select list of a SELECT statement | evaluates expression or the list of expressions and applies the hash function on the result. HASHROW returns the resulting row hash value. |
a list of expressions that can appear in the select list of a SELECT statement, where some expressions can evaluate to NULL |