Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
 Posted - 2008-04-22 : 10:36:30
|
| I know this is a stupid question, but I've searched and can't seem to find it. What do you use in SQL when creating a table and the field is a "yes/no" type field? In VB isn't that a boolean data type? What is the corresponding SQL data type? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-22 : 10:40:01
|
BIT.0 is false, all other values evaluates to 1 which means true.And there can eventually also be NULL (not known).
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2008-04-22 : 10:45:08
|
| Thanks Peso. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Boolean Data Type?