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.
Categories: SQL