BIT_XOR function [Aggregate]

BIT_XOR( bit-expression )

bit-expression The object to be aggregated. The expression can be a VARBIT array, a BINARY value, or an INTEGER (including all integer variants such as BIT and TINYINT).

The same data type as the argument. For each bit position compared, if an odd number of rows have a 1 in the bit position, return 1; otherwise, return 0.

SQL/2008 Vendor extension.

The following example generates four rows containing a CHAR column, then converts the values to VARBIT.

SELECT BIT_XOR( CAST(row_value AS VARBIT) ) 
FROM dbo.sa_split_list('0001,0111,0100,0011')

The result 0001 is determined as follows:

A bitwise exclusive OR (XOR) is performed between row 1 (0001) and row 2 (0111), resulting in 0110.
A bitwise XOR is performed between the result from the previous comparison (0110) and row 3 (0100), resulting in 0010.
A bitwise XOR is performed between the result from the previous comparison (0010) and row 4 (0011), resulting in 0001.

BIT_XOR function [Aggregate]

Syntax

Parameters

Returns

See also

Standards and compatibility

Example