Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-10 : 08:15:09
|
| Manuel Alves, aka Zé writes "I've been using bitwise operations on sql server 7 (SP3) and 2000 on select statments to check for membership:SELECT ... WHERE logicPartition & @bitPattern <> 0 ...I like it because it's very fast and it works well if the data belongs to just one "logicPartition" or several at the same time (several bits non-zero on "logicPartition") but I'm limited to 32 possible "logicPartitions" since this kind of operation is limited to 32 bit integers. Is there any trick to expand this functionality to 64, 128 or even larger bit patterns?Thank you for your time." |
|
|
|
|
|
Bitwise operations