Boolean Value In Sql
Just figured it out, in SQL, we have to type a "True" or "False" into a bit column. You can't use 1 and 0 instead, or otherwise, you will get a error:
========================================================
Invalid value for cell (row 1, column 1).
The changed value in this cell was not recognized as valid.
.Net Framework Data Type: Boolean
Error Message: String was not recognized as a valid Boolean.
Type a value appropriate for the data type or press ESC to cancel the change.
========================================================
It's fun, Microsoft may change this in the later version of SQL.
page revision: 0, last edited: 24 Sep 2007 11:58