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

What is db stored procedure?

0 Answers  


Why do we need different type of parameter?

0 Answers  


What is normalization in Database ?

4 Answers  


Do you know data definition language, data control language and data manipulation language?

0 Answers  


Is it true, that there is no difference between a rule and a check constraint?

0 Answers  






What is advantage data architect?

0 Answers  


what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  


What is filter index?

0 Answers  


What is the meaning of sql server?

0 Answers  


What are approximate numeric data types in ms sql server?

0 Answers  


What is the most common type of join?

0 Answers  


Is it possible to update the views? If yes, how, if not, why?

0 Answers  


Categories