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

What is dknf in normalization form?

0 Answers  


Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  


What are three SQL keywords used to change or set someone?s permissions?

3 Answers  


What is tcl in sql server?

0 Answers  


How many triggers are possible per table?

0 Answers  






Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  


How to display a past time in days, hours and minutes?

0 Answers  


Explain the types of indexes.

0 Answers   Accenture,


What is the difference function and stored procedure?

0 Answers  


What is the default order of an order by clause?

0 Answers  


Get Current System Date Time

2 Answers  


What are the types of dml?

0 Answers  


Categories