Does SQL Server have a boolean or a yes/no data type for its table columns?
Thanks in advance,
Bill>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.|||Hi Bill,
No it doesn't, people usually use the BIT data type which holds 0 or 1; some
folk like myself use Y or N / T or F in a char(1) column.
Tony.
--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]
"news" <wjfwjr@.hotmail.comwrote in message
news:eZOdnUO6lMk4AmDbnZ2dnUVZ_oCvnZ2d@.comcast.com. ..
Quote:
Originally Posted by
Sorry about this. But I've worked primarily in access for years.
>
Does SQL Server have a boolean or a yes/no data type for its table
columns?
>
Thanks in advance,
>
Bill
>
>
>
