what is bit data type? and what are the information that can
be stored inside a bit column?

Answers were Sorted based on User's Feedback



what is bit data type? and what are the information that can be stored inside a bit column?..

Answer / meena kurade

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 ?    3 Yes 0 No

what is bit data type? and what are the information that can be stored inside a bit column?..

Answer / sreejith s t


Bit is used to store boolean values . It stores 0 , 1 and
NULL .

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Which virtual table does a trigger use?

3 Answers  


What do you mean by normalisation?

1 Answers  


What is store procedure?

1 Answers  


How to store and query spatial data?

1 Answers  


how to know Who Is Blocking Your SQL Server?

4 Answers  


How to list all tables in the database using odbc_tables()?

1 Answers  


What is sql server english query?

1 Answers  


How to provide login information for a new odbc dsn?

1 Answers  


What is collation?

1 Answers  


What is clustered vs nonclustered index?

1 Answers  


What do you understand by intent locks?

1 Answers  


What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,


Categories