Integer data type that can be 1, 0, or NULL.
Columns of type bit cannot have indexes on them.
Microsoft® SQL Server™ optimizes the storage used for bit columns. If there are 8 or fewer bit columns in a table, the columns are stored as 1 byte. If there are from 9 to 16 bit columns, they are stored as 2 bytes, and so on.
| ALTER TABLE | DELETE |
| CAST and CONVERT | INSERT |
| CREATE TABLE | SET @local_variable |
| Data Type Conversion | UPDATE |
| Data Types | syscolumns |
| DECLARE @local_variable |