Login
Remember
Register
Ask a Question
What are bitwise operators and what is the value from a database design perspective?
+2
votes
asked
Jan 15, 2022
in
Sql
by
GeorgeBell
What are bitwise operators and what is the value from a database design perspective?
t-sql
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jan 15, 2022
by
GeorgeBell
The bitwise operators in SQL Server are:
& (Bitwise AND)
~ (Bitwise NOT)
| (Bitwise OR)
^ (Bitwise Exclusive OR)
From a database design perspective, bitwise operators can be used to store a complex set of criteria as a single value as opposed to having numerous lookup tables or numerous columns used as a 'flag' or condition indicator.
...
