what is bit data type? and what are the information that can
be stored inside a bit column?
Answer Posted / 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 |
Post New Answer View All Answers
Do you know the capabilities of cursors?
How to compare the top two records using sql?
What is tempdb database? : SQL Server Architecture
What are cascading parameters in ssrs reports?
What is a partition key?
What is the difference between writing data to mirrored drives versus raid5 drives
How to use old values to define new values in update statements in ms sql server?
Difference between uniqe index and uniqe constraint?
How do I find the default sql server instance?
How to delete duplicate rows?
What is difference between count (*) and count column?
What are the restrictions while creating batches in sql server?
Explain system rowset functions?
What is the difference between a local and a global temporary table?
What do you mean by subquery?