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
Moderator
http://www.SQL-Server-Performance.Com/forum
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

]]>