How to Use the BIT

Step 1: Create database w3wiki by using the following SQL query

CREATE DATABASE w3wiki

Step 2: Use the GFG Database.

USE w3wiki

Step 3: Create a Table with the Name studentsFeesInfo which Contains the studentIds, Names and their fee status.

CREATE TABLE studentsFeesInfo(
studentId INT PRIMARY KEY,
studentName VARCHAR(100),
isFeePaid BIT
);

Explanation: The table with a column name isFeePaid with BIT data type is created.

Step 4: Insert the Sample Data into the Table.

Explanation: Here we can see that for all the students the isFeePaid column of BIT data type is either 0 or 1.

Step 5: Check the table

SELECT *  FROM  studentsFeesInfo

The BIT data type is used to store boolean values like 0, 1, or NULL. The SQL server doesn’t have the data Boolean instead it has the data type BIT which has which stores the boolean value. The BIT data type is advantageous in terms of space optimization since each BIT data type takes on only 1 bit of storage, suppose their n columns in the table with the BIT data the ceil value of n/8 bytes will be used i.e if there 0-8 columns with bit data type then it will be stored as 1 byte.

SQL server even converts the following assignment into 0 or 1 values:

• When the column of bit data type assigned with ‘TRUE‘ or ‘FALSE‘ is converted to 1 or 0 respectively, other than there strings it will throw an error for other strings.
• When the column of bit data type assigned with any nonzero values will be converted to 1 respectively.

Syntax:

CREATE TABLE  table_name
(
column_name BIT
);

Explanation: Using the BIT data type after our desired column name make the column of BIT data type.