• I actually expected that error because your varchar columns are all defined with a length of 1. This is the number in parentheses. When you define a character column (char/varchar/nchar/nvarchar) you need to define a length. You could change my insert to just insert 1 character in each of the columns to test the bit column, but you really should re-create the table with appropriate lengths for your columns and then re-run the insert.