What Is Bit Datatype And What's The Information That Can Be Stored In

1.	What Is Bit Datatype And What's The Information That Can Be Stored Inside A Bit Column?
Answer» Bit DATATYPE is used to store BOOLEAN information like 1 or 0 (true or false). Untill SQL Server 6.5 bit datatype COULD hold either a 1 or 0 and there was no SUPPORT for NULL. But from SQL Server 7.0 onwards, bit datatype can represent a third state, which is NULL. Bit datatype is used to store boolean information like 1 or 0 (true or false). Untill SQL Server 6.5 bit datatype could hold either a 1 or 0 and there was no support for NULL. But from SQL Server 7.0 onwards, bit datatype can represent a third state, which is NULL.

What Is Bit Datatype And What's The Information That Can Be Stored Inside A Bit Column?

Answer»

Bit DATATYPE is used to store BOOLEAN information like 1 or 0 (true or false). Untill SQL Server 6.5 bit datatype COULD hold either a 1 or 0 and there was no SUPPORT for NULL. But from SQL Server 7.0 onwards, bit datatype can represent a third state, which is NULL.

Bit datatype is used to store boolean information like 1 or 0 (true or false). Untill SQL Server 6.5 bit datatype could hold either a 1 or 0 and there was no support for NULL. But from SQL Server 7.0 onwards, bit datatype can represent a third state, which is NULL.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Values That Can Be Specified For Optimizer Mode Parameter ?
What Is A Trace File And How Is It Created ?
How Many Number Of Columns A Record Group Can Have?
What Does The Term Panel Refer To With Regard To Pages?
What Is A Master Detail Relationship?
What Is A Library?
What Erase Package Procedure Does ?
What Is Mean By Program Global Area (pga) ?
What Is The Use Of Parfile Option In Exp Command ?
What Is Overloading Of Procedures ?