what is bit data type? and what are the information that can
be stored inside a bit column?
- 2 Answers
- 3530 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What are acid properties of transaction?
What is the primary use of the model database?
How is sql server used?
What is ms sql server reporting services?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What are wait types?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
Explain trigger and its types?
What happens to a statement batch if there is a compilation error?
Why do we backup Active Directory ?
Diffrence between DTS vs SSIS
Explain the purpose of indexes?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
