Script with checkbox

1

Hello,

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.

2

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);
GO

INSERT MyTable(MyCheckBox)
VALUES
   (0),(NULL),(1);
SELECT 
UPDATE MyTable
SET MyCheckBox=1;