[dba-SQLServer] Yes/No in SQL Server

On 1/1/06, Dan Waters <dwaters at usinternet.com> wrote:
>
> John,
>
> I checked a table that I upsized into SSE 2005.  A previous Yes/No is now
> a
> bit, and the data displays as True or False in the table column.


One other point that may not be immediately obvious: in Access, yes/no
values are stored as -1 or 0; in SQL Server bit values are stored as 1 or 0.


Stephen