[AccessD] True / false in SQL Server

Bobby Heid bheid at sc.rr.com
Mon Jan 16 13:59:37 CST 2012


We use the bit data type at work.  Either 1 or 0.  Your sproc could return
-1 for 1 if you like.  We are not using access, so 1 for true works out fine
for us.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, January 16, 2012 12:09 PM
To: VBA; Access Developers discussion and problem solving
Subject: [AccessD] True / false in SQL Server

Because of various issues with bit and Access I have always used int as the
data type and -1 or 0 as the default value.  These can be bound directly to
a check box (for example).

Because the default int is a 32 bit number I was just looking to see if I
could use a smaller data type.  A smallint is 2 bytes and includes negative
values.  A tinyint does not appear to allow -1. 
Is there a signed byte datatype that I am not seeing?

--
John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list