1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / swapna


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

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

What is the use of stored procedure?

0 Answers  

What is lookup override?

0 Answers   Informatica,

What are the different acid properties?

0 Answers  

What is tabulation?

0 Answers  




What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  

what is a cursor and what is its use?

2 Answers   L&T,

Do you know the isolation level that sql server support?

0 Answers  

What is log shipping?

0 Answers  

Explain different types of locks in sql server.

0 Answers  

what is physical sort data and logical sort data in index?

2 Answers  

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories