ProAnswers.org

What is bit data type?

Bit data type is used to store Boolean information like 1 or 0 (true or false).

Until SQL Server 6.5 bit data type could hold either a 1 or 0 and there was no support for NULL. But from SQL Server 7.0 onwards, bit data type can represent a third state, which is NULL.