[dba-SQLServer] Yes/No in SQL Server

Dan Waters dwaters at usinternet.com
Sun Jan 1 14:09:45 CST 2006


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.

Dan Waters

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin
Sent: Sunday, January 01, 2006 2:00 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Yes/No in SQL Server

John

Its just a bit data type 0 or 1 representing T or F.
 martin


-----Original Message-----
    From: "Mark Rider"<ridermark at gmail.com>
    Sent: 01/01/06 18:03:05
    To:
"dba-sqlserver at databaseadvisors.com"<dba-sqlserver at databaseadvisors.com>
    Subject: Re: [dba-SQLServer] Yes/No in SQL Server
    
    AFAIK, the bit is eiher 0 or 1.  USually 0 is False (NO) and 1 is True
    (YES). I use bit values to determine if something needs to be changed or
has
    been changed - for example a Midified filed is set to "0"  at the outset
and
    then a bunch of calculations are done.  If the value returned by the
    calculations has changed from the original value, I change the Modified
    Field to "1" so that further changes to the value are ignored.
    
    What are you trying to accomplish?
    
    On 1/1/06, John Colby <jwcolby at colbyconsulting.com> wrote:
    >
    > So what happens internally?  Does SQL Server pack/unpack as many y/n
    > (boolean) values as will fit in an integer or something like that?
    >
    >
    > John W. Colby
    > www.ColbyConsulting.com
    >
    > Contribute your unused CPU cycles to a good cause:
    > http://folding.stanford.edu/
    > -----Original Message-----
    > From: dba-sqlserver-bounces at databaseadvisors.com
    > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
    > Harkins
    > Sent: Sunday, January 01, 2006 11:24 AM
    > To: dba-sqlserver at databaseadvisors.com
    > Subject: Re: [dba-SQLServer] Yes/No in SQL Server
    >
    > bit
    >
    > Susan H.
    >
    > What data type is used to store Boolean values in SQL Server?
    >
    >
    >
    > _______________________________________________
    > dba-SQLServer mailing list
    > dba-SQLServer at databaseadvisors.com
    > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
    > http://www.databaseadvisors.com
    >
    > _______________________________________________
    > dba-SQLServer mailing list
    > dba-SQLServer at databaseadvisors.com
    > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
    > http://www.databaseadvisors.com
    >
    >
    
    
    --
    Mark Rider
    http://commonsensesecurity.info
    
    There are 10 kinds of people in the world:
    Those who understand binary and those who don't.
    _______________________________________________
    dba-SQLServer mailing list
    dba-SQLServer at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
    http://www.databaseadvisors.com
    

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list