what is bit data type? and what are the information that can
be stored inside a bit column?
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 the parts of a function?
How to view existing indexes on an given table using sys.indexes?
How to check parameter value in stored procedure sql server?
How to run sql server 2005 books online on your local system?
What is the purpose of data source?
How do indexes help, types?
What is correlated subquery in sql server?
What are the Advantages of using CTE in sql server?
What is a transactions?
What are the 7 disadvantages to a manual system?
What is efficiency data?
How to create an index on an existing table in ms sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)