Tags: clash, database, delete, incompatible, insert, microsoft, mysql, operand, oracle, procedureon, prod, rows, server, servers, sql, stage, stored, tableon, text, type, update, varbinary
Operand type clash: varbinary is incompatible with text
I have 3 SQL Servers (DEV, STAGE and PROD). I have a stored procedure
on DEV that will UPDATE, INSERT and DELETE rows of data from one table
on DEV to the same table on STAGE. This works fine.
I have the exact same stored procedure on STAGE that will UPDATE,
INSERT and DELETE rows of data from one table on STAGE to the same
table on PROD. This DOES NOT WORK.
All three servers have the same database and table schema. Everything
works from from DEV to STAGE. But when I try to run the stored
procedure from STAGE to PROD it fails with the following error message:
"Operand type clash: varbinary is incompatible with text"
This error above only occurs on tables that have TEXT fields. The
strange thing is it works from DEV to STAGE and they both have fields
of TEXT type as well.
Leave a comment...
- 0 Comments