Bit data type | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Bit data type

Hi All,
Well, i finally got a copy of SQL Server 2005 to play with, and after 2 days of absolutely loving it, i have found something i hate, and am hoping someone knows a way to change it… When i open a table that as columns of data type Bit, the values are displayed as true or false, not 0 or 1 as in SQL Server 2000, and also have to be entered as True or False…is there a way to change this back to 0’s and 1’s??? Thanks, Ben
Have you tried this from query editor. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
The query editor displays 0’s and 1’s and also accepts these as the input, but if i open a table and enter a row manually (as we do from time to time) i have to put True/False