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