When performing UPDATE on a VARCHAR (4) column using an integer value in the SET clause.
UPDATE TESTE SET ID = 9250 WHERE ID = 1234
The following error is returned:
Conversion failed when converting the varchar value '????' to data type int.
However the error occurs only on one of the servers running SQL Server 2008 R2, the other server that has the identical version does not get the error, but I was unable to identify if it has any different parameters from one server to another. Has anyone seen this type of error ???