Incorrect syntax with bit

[expired user #9574]'s profile image [expired user #9574] posted 7 years ago in General Permalink

Hi,

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.