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 is difference between sql and sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What is the process of indexing?
What is rolap and its advantage? : sql server analysis services, ssas
Can you please differentiate between a primary key and a unique key?
What do you understand by a view? What does the with check option clause for a view do?
syntax for deleting the database in T SQL
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
What are the dis_advantages of stored procedures, triggers, indexes?
What are the steps to process a single select statement?
Explain transaction server consistency?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
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)