[dba-SQLServer] Yes/No in SQL Server

Stephen Hait shait at mindspring.com
Sun Jan 1 14:29:49 CST 2006


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



More information about the dba-SQLServer mailing list