Tuesday, April 12, 2011

What is bit datatype and what's the information that can be stored inside a bit column?

Bit datatype is used to store Boolean information like 1 or 0 (true or false). Until 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.
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
  • Hexadecimal Byte, UInteger and Integer
    Option Strict On Public  Module modMain     Public Sub  Main ()        Dim  maxValue  As  Byte = &HFF        Dim  posValue  As  UIn...
  • Add two integers together
    Module Tester     Sub  Main ()        Dim  firstNumber, secondNumber  As  String        Dim  number1, number2, sumOfNumbers  As  Intege...
  • The Text Property of a Control
    Changing the values of some properties is fairly easy. We'll now change the Text properties of our labels, and the Text properties of o...