Bit Data Type in SQL Server

Question

Hi What is bit data type in SQL Server and what is the information that can be stored inside a bit column ?

Senthilkumar · Answer

Hi, Bit data type is used to store the boolean information. Sql server designed to store the boolean as bit in sql server table, which can accept the integer value. It will have single bit and user can store the 1 or 0. They can store the null value as well. 1 - True 0 - False when the value is stored as 1 then it is true and 0 for false. Lets see how to use in sql server: BIT data type is a special kind of integer that could be either true or false. It is used to store 0,1 or Null, We could use this data type to keep track of whether a user accound is Enabled or Disabled. You can use it like a BOOLEAN variable. Possible Values: 0 - FALSE 1 - TRUE NULL CREATE TABLE USER_ACCOUNT ( USER_NAME VARCHAR(256) NOT NULL, IS_ENABLED BIT ) When we insert a record to this table, SQL SERVER stores 0, 1 or NULL in the IS_ENABLED column.The value 0 represents 'FALSE' and 1 represents 'TRUE'.When using the value 'TRUE' or 'FALSE', remember to enclose the value with single quotes. Following commands are used to insert records to the USER_ACCOUNT table: In this first example, we insert a value 'FALSE' into the table, Sql Server stores 'FALSE' as 0 in the BIT datatype column INSERT INTO USER_ACCOUNT VALUES ('MIC','FALSE') Next, we enable the user by updating IS_ENABLED BIT value from 0 to 1. Following command inserts value 'TRUE' into the BIT column UPDATE USER_ACCOUNT SET IS_ENABLED='TRUE' WHERE USER_NAME='MIC' Also we could use interger values to insert or update the BIT data type. UPDATE USER_ACCOUNT SET IS_ENABLED=1 WHERE USER_NAME='MIC'

Vulpes · Answer

'bit' is one of the integer data types in SQL Server. It can store the values 1, 0 or NULL. It can also be used to store boolean values because TRUE is convertible to 1 and FALSE is convertible to 0.

geetha velusamy · Answer

The BIT data type is used to store bit values. A type of BIT enables storage of bit values.To specify bit values, ' value ' notation can be used. value is a binary value written using zeros and ones. Defining BIT: If there are 8 or fewer bit columns in a table, the columns are stored as 1 byte. If there are from 9 up to 16 bit columns, the columns are stored as 2 bytes, and so on. The string values TRUE and FALSE can be converted to bit values,TRUE is converted to 1 and FALSE is converted to 0.

nada leko · Answer

how about setting to NULL ? UPDATE USER_ACCOUNT SET IS_ENABLED=NULL WHERE USER_NAME='MIC' does not seem to work... why?

Bit Data Type in SQL Server

Answers (4)