what is bit data type? and what are the information that can
be stored inside a bit column?
- 2 Answers
- 3511 Views
- I also Faced
- E-Mail Answers
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
What is the distinction amongst delete and truncate?
What is log shipping?
What is isnull() operator?
what is the primary use of the model database? : Sql server administration
What does normalization do to data?
How do I clean up sql server transaction log?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
Can a database be shrunk to 0 bytes, if not, why?
What are various aggregate functions that are available?
What is clustered vs nonclustered index?
How to encrypt data between dialogs?
In what three ways is the return statement used in a stored procedure?
What is default constraint?
what does the automatic recovery do? : Sql server administration
What are the types of indexes?
