• Dave62 (1/28/2010)


    A little more information about the BIT type. The bit type has 3 states: NULL, 0, and 1. . . .

    I don't think that's quite right. It's not that a BIT datatype has three states -- wouldn't that be a "trit"? -- but that ANY data element may be designated as nullable or not, and nullable is the default case for columns and the only choice for variables. If a column is nullable, there's an internal switch maintained to designate the field as null.