BigQuery, MySQL, Spanner, and Sybase provide a bit_xor aggregate function, which can run a bitwise XOR operation on all 64-bit integers in a group (from a GROUP BY query).
How would I run an aggregate bitwise XOR in Microsoft SQL Server?
Asked
Active
Viewed 1,103 times
0
Tim Swast
- 14,091
- 4
- 38
- 61
-
Maybe this can be done with a custom aggregate function? https://learn.microsoft.com/en-us/sql/t-sql/statements/create-aggregate-transact-sql?view=sql-server-ver15 – Tim Swast Jul 22 '20 at 21:32
-
Yes, you could write a custom aggregate. A cursor would also work. – shawnt00 Jul 22 '20 at 21:37
-
https://stackoverflow.com/questions/3981050/aggregate-bitwise-or-in-a-subquery – shawnt00 Jul 22 '20 at 21:40
-
1You could mask off the bits into 64 columns, count them up, and test for odd or even. – shawnt00 Jul 22 '20 at 21:42
1 Answers
0
The ^ bitwise operator in SQL Server performs a bitwise logical exclusive OR between the two expressions, taking each corresponding bit for both expressions.
Example:
SELECT a_int_value ^ b_int_value
FROM bitwise;
GO
For aggregate bitwise xor SQL Server does not have native support but you can create a function as below:
Gabriele Franco
- 879
- 6
- 10
-
Yes, but what about across all values in a group (aggregate)? Can this be used with a custom aggregate? – Tim Swast Jul 22 '20 at 21:35
-
-