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

Answer Posted / swapna

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.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain transaction server isolation?

544


What do you mean by recursive stored procedure?

508


What is format parameter in ssrs?

109


How to use order by with union operators in ms sql server?

574


What are constraints?

585






Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

611


What is scd (slowly changing dimension)? : sql server analysis services, ssas

590


What is the meaning of sql server?

526


Explain various data region available in ssrs with their use?

490


What are logical/boolean operations in ms sql server?

539


Tell me what is sql profiler?

617


Do you know what is similarity and difference between truncate and delete in sql?

574


How to define output parameters in stored procedures?

517


List some case manipulation functions in sql?

592


Which is better statement or preparedstatement?

518