What is bit datatype and what's the information that can be
stored inside a bit column?
Answer Posted / 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 View All Answers
Where are SQL server users names and passwords are stored in sql server?
What is data compression? : sql server database administration
Does server sql treat char as a variable-length or fixed-length column?
How to create user messages with print statements in ms sql server?
What is the difference between a "where" clause and a "having" clause?
What happens if strings are casted into wrong code pages in ms sql server?
What do you understand by mirroring and mention the advantages of the mirroring?
What is stretch database in sql server?
What is use of except clause? How does it differ from not in clause?
When to use Inner join & when to use subquery?
How to return the top 5 rows from a select query in ms sql server?
How to enter unicode character string literals in ms sql server?
What is a transact-sql statement?
What is set nocount on?
How to create a view on an existing table in ms sql server?