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.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License