SQL Server Performance

Bit data type

Discussion in 'SQL Server 2005 General DBA Questions' started by benwilson, Jun 9, 2005.

  1. benwilson New Member

    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???


  2. satya Moderator

  3. benwilson New Member

    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

Share This Page