Okay so this is a bit of a double question problem, but they are both related. The first question is how would I set a default value for my column as I want it to be
true/1 (it's a bit column in case you hadn't guessed) and the second issue is that I have a row of checkboxes and I want these to be ticked when I have the value set
as true, my current command is:
cmd.CommandText = "ALTER TABLE tbl_ecom_cat_feature ADD display_on_search BIT";
Thanks in advance!