what is the signification difference of this bit data type between sql 6.5 and

what is the signification difference of this bit data type
between sql 6.5 and later version sql server?

Question Posted / ynpradeep

what is the signification difference of this bit data type between sql 6.5 and later version sql s..

Answer / sreejith s t

In SQL 6.5 bit datatype supports only 0 and 1 ( true /
false ) . But in later versions it supports NULL also .

Is This Answer Correct ?

4 Yes

0 No

More SQL Server Interview Questions

What are the rules to use the rowguidcol property to define a globally unique identifier column?

How to delete the duplicate rows from a table in SQL Server ??

Can a table have 2 foreign keys?

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

How to convert numeric expression data types by assignment operations?

Explain how to send email from sql database?

Do you know what are acid properties of transaction?

What is the difference between a clustered index and a non-clustered index?

What is an example of a primary key?

What is transaction server consistency?

What happens if the update subquery returns multiple rows in ms sql server?

what is the difference between Delete and Truncate command in SQL

For more SQL Server Interview Questions Click Here