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
When would you prefer to have a minimum number of indexes?
What is attribute? : sql server analysis services, ssas
What is a recursive stored procedure in sql server?
What is user defined datatypes and when you should go for them?
What are parameterized reports?
What are different types of constraints?
do views contain data ?
What is the difference between coalesce() & isnull()?
What are the database roles? : sql server security
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is the difference between function and stored procedure in sql server?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What is purpose of normalization?
What do you understand by a view?
SQL Server Architecture ?