>> Does SQL Server have a boolean or a yes/no data type for its table columns? <<
No, and you should not write SQL that way -- bit flags are too low
level for a high level language. We left BOOLEANs out for good
reasons having to do with 3VL, NULLs and consistent language model.