dumb question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

news - 29 Sep 2007 01:43 GMT

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

Reply to this Message

--CELKO-- - 29 Sep 2007 01:55 GMT

>> 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.

Reply to this Message

Tony Rogerson - 29 Sep 2007 10:20 GMT

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.

Signature

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]

> Sorry about this. But I've worked primarily in access for years.
>
[quoted text clipped - 4 lines]
>
> Bill

Reply to this Message