[dba-SQLServer] Yes/No in SQL Server

That is what I was wondering.  Thanks!


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 Billy Pang
Sent: Sunday, January 01, 2006 4:32 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Yes/No in SQL Server

from bol "Microsoft. SQL Server optimizes the storage used for bit columns.

If there are 8 or fewer bit columns in a table, the columns are stored as 1
byte. If there are from 9 through 16 bit columns, they are stored as 2
bytes, and so on."


>From: "John Colby" <jwcolby at colbyconsulting.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: Re: [dba-SQLServer] Yes/No in SQL Server
>Date: Sun, 1 Jan 2006 12:46:25 -0500
>
>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
>