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 |
Explain indexed view?
What is user-defined multi-statement table-valued function?
About types of indexes in SQL server ?
What is implicit cursors?
Do you know what is sql injection?
How to delete the duplicate rows from a table in SQL Server ??
What is a data collection table?
WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.
Explain magic tables in sql server?
What are number line correlation administrators will use while working with a subquery?
How to swap the data of two columns in a table. both the columns containing varchar values.
Define primary key?
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)