Is SQL Management Studio expected to automatically display bit as true/false without manually conversion?

Viewed 1136

Update:

No one doesn't seem to understand my question.

In Return Bit Value as 1/0 and NOT True/False in SQL Server, the person says

I have a Table in SQL Server 2000 with BitValue Column. But, it is being displayed as True/False in SQL Server Management Studio.

In How do you create a yes/no boolean field in SQL server?, a user says

In SQL you use 0 and 1 to set a bit field (just as a yes/no field in Access). In Management Studio it displays as a false/true value (at least in recent versions).

All these seem to indicate Management Studio displays bit as a false/true value, ie. select cast(1 as bit) will display as true.

But it doesn't happen for me.

Does anyone know why?

select cast(1 as bit) returns 1, not true

5 Answers
Related