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

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

Question Posted / ynpradeep

2 Answers
4526 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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

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

Post New Answer

More SQL Server Interview Questions

Can you explain important index characteristics?

0 Answers

What do you understand by physical_only option in dbcc checkdb?

0 Answers

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers DELL,

What is the purpose of self join?

0 Answers

What is the use of set nocount on/off statement?

0 Answers

What is awe?

0 Answers

what is macro?

5 Answers Excel, Global Innovation, Wipro,

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers

What are acid properties of transaction?

0 Answers

Explain for xml explicit mode?

0 Answers

Explain the truncate command? : SQL Server Architecture

0 Answers

For more SQL Server Interview Questions Click Here