I met a code that CONVERT(BIT, Value) and insert into BIT column. Let’s see what are the possible values.
I needed to quote an identifier (a column name) with “<“. I checked the documentation for the build-in function QUOTENAME() and I did not find the information that I need. Here is a quick T-SQL to show which characters we can use as a second argument of the function.