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

Explain the difference between primary keys and foreign keys?

0 Answers  

Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,

How to enter date and time literals in ms sql server?

0 Answers  

List the various tools available for performance tuning?

0 Answers  

how to rest identity columns in sql server

3 Answers   Matrix,




how to control the amount of free space in your index pages? : Sql server database administration

0 Answers  

How much space does sql server 2016 take?

0 Answers  

What is @@rowcount in sql?

0 Answers  

how to overcome kernel isssues

0 Answers   Fortune,

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,

how do u find least salary in a table

4 Answers  

What is use of except clause? How it differs from not in clause?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories