MSSQL - Fix Error - Column, parameter, or variable #7: Cannot find data type BOOL.

error Column, parameter, or variable #7: Cannot find data type BOOL.

watch solution on YouTube

To fix it replace
ALTER TABLE Product

ADD thisIsFinalSale BOOL NOT NULL DEFAULT(0)

GO

with

ALTER TABLE Product

ADD thisIsFinalSale BIT NOT NULL DEFAULT(0)

GO