SQL SERVER | Bitwise operations on an int/smallint/tinyint field

Question

I was wondering if you can do bitwise operations on an int/uint fields in SQL SERVER?

Answer 1

Um.... it's a BIT what value would you like to store other than 0 or 1? So direct answer, no.

Edit. I answered your topic, not your description. Please clarify question.

Answer 2

Bits contain 0 and 1, that's it.

Answer 3

Sorta :-) but you are limited to only one bit so you only have 0 or 1 to work with

Answer 4

Yes, you can do bitwise operations on int/uint fields.

For example, consider this:

declare @myvar int
set @myvar = 3
if ((@myvar & 2) = 2)
begin
   print 'hello'
end

Answer 5

Yes, you can, at least in Transact-SQL. See Microsoft's SQL Server documentation.

Answer 6

The answer is YES !

Just because they're called bitwise operators, dopes not mean they only operate on data values stored in the SQL Server "Bit" typoe.

All data is stored in the computer as bits... so you can use the Bitwise operators on many types, including any integral types int, smallint, tinyint, etc..

the bitwise operators are not use-limited to Bit type values.

I don't know if you can use it on other types,, but just try it and see what happens...