Transact-SQL boolean data types?

wyrd

Well-known member
Joined
Aug 23, 2002
Messages
1,408
Location
California
Im creating a table to keep track of items for a small business and wanted to create a boolean column called obsolete. If set to true, the item is obsolete and no longer sold, if set to false then its a current item that can be purchased or back ordered.

While looking through BOL, I noticed that there was no boolean data type. So my question is, what is the best way to handle true/false columns? Just use a bit column (0 = false, 1 = true)?
 
Back
Top