TheDrParker
Programmer
When I try this:
UPDATE [Certifications] SET [Verified] = 'True' WHERE [Employee Name] = 'Buttros, Peter' AND [Certification] = 'MCSE' AND [Verified] = 'False';
I get:
…[SQL Server]Syntax error converting the varchar value 'False' to a column of data type bit.
And when I try this:
UPDATE [Certifications] SET [Verified] = True WHERE [Employee Name] = 'Buttros, Peter' AND [Certification] = 'MCSE' AND [Verified] = False;
I get:
…[SQL Server]Invalid column name 'True'.
What am I doing wrong or missing?
UPDATE [Certifications] SET [Verified] = 'True' WHERE [Employee Name] = 'Buttros, Peter' AND [Certification] = 'MCSE' AND [Verified] = 'False';
I get:
…[SQL Server]Syntax error converting the varchar value 'False' to a column of data type bit.
And when I try this:
UPDATE [Certifications] SET [Verified] = True WHERE [Employee Name] = 'Buttros, Peter' AND [Certification] = 'MCSE' AND [Verified] = False;
I get:
…[SQL Server]Invalid column name 'True'.
What am I doing wrong or missing?