T-SQL Hint: What are the values that we can insert into BIT column


I met a code that CONVERT(BIT, Value) and insert into BIT column. Let’s see what are the possible values.

The possible values are NULL, 0 and 1 and conversion is not needed.

Keep it simple :-)