what is bit data type? and what are the information that can
be stored inside a bit column?
- 2 Answers
- 3689 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 |
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What is delete query?
How to write stored procedure to update the data in 10 tables
How to delete existing triggers using "drop trigger"?
How would you add a section to a table?
Can we use pragma autonomous_transaction in trigger?
Is it true, that there is no difference between a rule and a check constraint?
What is a collation?
Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.
How to provide column names in insert statements in ms sql server?
What is the difference between migration and upgradation in sql server?
Can anybody explain me cold backup and hot backup?
-
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)
