Wednesday, 3 October 2007

bit columns

I was looking at some T-SQL that RJ had written and noticed he was using 'True' and 'False' when dealing with bit data types.

I've always used 1 and 0, but I think 'True' and 'False' is more obvious, and I think I'll start using it from now on. 

Sure enough, the SQL 2005 Books Online entry for bit (Transact-SQL) mentions this:

The string values TRUE and FALSE can be converted to bit values: TRUE is converted to 1 and FALSE is converted to 0.

No comments: