Aaron Bertrand answers a question:
Recently someone posted a question where they couldn’t quite figure out how to construct a predicate based on a
bitparameter. They tried to write a procedure like this, which wouldn’t parse, of course:
At first, I thought Aaron meant querying integer bitmasks in T-SQL, in which case, the best strategy is “don’t.” But this is a different and much more useful scenario.