what is bit data type? and what are the information that can
be stored inside a bit column?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how to send email from sql database?

730


What is difference between unique and primary key?

650


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1554


What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

764


How to provide default values to function parameters?

763






What is cube dimension? : sql server analysis services, ssas

711


How to make a remote connection in a database?

705


What is not null constraint?

814


What number aggregate functions are accessible there in sql?

772


what is denormalization? : Sql server database administration

654


What are filegroups in sql server?

776


What is stored procedures?

715


Explain the collation?

824


How dts is used to extract, transform and consolidate data?

789


How to create sub reports?

210