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



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

Answer / 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

More SQL Server Interview Questions

How do I create an extended event in sql server?

1 Answers  


Explain how dts is used to extract, transform and consolidate data?

1 Answers  


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1 Answers   HP,


Differentiate between ms sql server reporting services vs crystal reports?

1 Answers  


What are the security related catalog views? : sql server security

1 Answers  


How to create an multi-statement table-valued function?

1 Answers  


What is sql server 2000 work load governor?

1 Answers  


How to generate create procedure script on an existing stored procedure?

1 Answers  


Explain what is analysis service repository?

1 Answers  


Is it possible to call a stored procedure within a stored procedure?

1 Answers  


How to create nested stored procedure?

1 Answers  


What are the different types of Indexes available in SQL Server?

1 Answers  


Categories