T-SQL XOR Operator

by

There is a bitwise XOR operator – the caret (^), i.e. for:

SELECT 170 ^ 75

The result is 225.

For logical XOR, use the ANY keyword and NOT ALL, i.e.

WHERE 5 > ANY (SELECT foo) AND NOT (5 > ALL (SELECT foo))

More Related Contents:

  1. SQL Server – error when creating stored procedure
  2. How can foreign key constraints be temporarily disabled using T-SQL?
  3. How can I escape square brackets in a LIKE clause?
  4. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  5. Datatype for storing ip address in SQL Server
  6. Is there a way to loop through a table variable in TSQL without using a cursor?
  7. Maximum size of a varchar(max) variable
  8. best way to convert and validate a date string
  9. How to get a date in YYYY-MM-DD format from a TSQL datetime field?
  10. How do I format a number with commas in T-SQL?
  11. Is there a way to simplify a NULL compare of 2 values
  12. TSQL Try / Catch within Transaction or vice versa?
  13. What is the maximum number of characters that nvarchar(MAX) will hold?
  14. TSQL: Create a view that accesses multiple databases
  15. Sequence as default value for a column
  16. Aggregate bitwise-OR in a subquery
  17. How do I flush the PRINT buffer in TSQL?
  18. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  19. OR Operator Short-circuit in SQL Server
  20. How to change default language for SQL Server?
  21. T-SQL incrementing counter based on change in a column value
  22. Cannot bulk load. Operating system error code 5 (Access is denied.)
  23. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  24. Does query plan optimizer works well with joined/filtered table-valued functions?
  25. comma delimited list as a single string, T-SQL [duplicate]
  26. SQL SERVER – Understanding how MIN(text) works
  27. Pivot multiple columns based on one column in SQL Server
  28. @@ERROR and/or TRY – CATCH
  29. INSERT INTO @TABLE EXEC @query with SQL Server 2000
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment