Application of BIT data type in SQL Server

Application of BIT data type in SQL Server

All users who have used access know that access has a "Yes/No" data type. This type is not used in SQL Server.Bit. Pay attention to the following points during use:

1,BitIt is similar to the integer and numeric data of SQL Server,BitColumns can only store 0 and 1.

2. Insert and modifyBitUse 0 or 1 instead of false or true for data,BitThe same is true for fields in the where query condition.

3. Use recordsetBitAfter the data in the field is obtained, it is 'boolean' type, not 'number' type. That is, if RS ("bitfield") then should be used in the judgment, instead of If RS ("bitfield ") = 1 then.

Bit can accept any type of data, but data other than 0 and 1 will be stored as 1, and null is not allowed!