BIT (TSQL Datatype)

Is a one-byte unsigned integer, containing only 0, 1.

BIT

0, 1

When a number of another datatype is converted to bit, any nonzero value is converted to 1.

The storage on disk used by bit is one byte, not one bit.

There is no syntax for writing a literal bit.

You just use a literal int, and it will be converted to bit.

DECLARE @a BIT;
SET @a = 1;      -- 1 is a literal 'int'

DECLARE @a BIT = 1;
DECLARE @b BIT = 0;

PRINT @a & @b;
PRINT @a ^ @b;

The result is:

0
1

Guide