Script with checkbox


I'm new to writing scripts.
I want to run a script and have it automatically check the boxes if any part numbers match on my table.

so for example in my database i have a part number ABC with a checkbox unchecked. I want to be able to run a script against it and have it check it automatically.

A Check Box is an application object. SQL Server has a bit datatype that currently supports 3 values; 0, 1 and NULL. A data driven application may represent a bit column as a check box.
TO update all the rows of a table with a bit column:

CREATE TABLE MyTable(ID int identity not null primary key, MyCheckBox bit);

INSERT MyTable(MyCheckBox)
SET MyCheckBox=1;