Incorrect syntax with bit

jan.zahora posted 1 year ago in General


I use MSSQL 10 (or MSSQL 12). Error occurred with Incorrect syntax near '0'. when I try update BIT type cell from database grid.

Log StringList: UPDATE TOP(1) "DatabaseName"."dbo"."TableName" SET " BitColumn"='1' WHERE "BitColumn"=b'0';

Please login to leave a reply, or register at first.