Columns of data type varbinary(max), varchar(max), or nvarchar(max) always assigned a NULL value when $operation = 1 or $operation = 3. how to resolve this.

UDAY KIRAN 0

Columns of data type image, text, and ntext are always assigned a NULL value when __$operation = 1 or __$operation = 3. Columns of data type varbinary(max), varchar(max), or nvarchar(max) are assigned a NULL value when __$operation = 3 unless the column changed during the update.

Olaf Helper 42,746 Reputation points

2024-06-11T05:46:05.5066667+00:00

Your post is very unclear, may can you provide more details, please?

Which application/tool, what for "operations", which commands etc.?
Erland Sommarskog 104.7K Reputation points MVP

2024-06-11T21:28:37.7033333+00:00

How to resolve this? Correct your code, I guess.

How you would correct it? No idea, since you have not shown the code you are using.
LiHongMSFT-4306 25,326 Reputation points

2024-06-12T02:40:08.5466667+00:00

Hi @UDAY KIRAN

What do you mean when __$operation = 1 or __$operation = 3? Please clarify this.

Share via

Columns of data type varbinary(max), varchar(max), or nvarchar(max) always assigned a NULL value when __$operation = 1 or __$operation = 3. how to resolve this.

Columns of data type varbinary(max), varchar(max), or nvarchar(max) always assigned a NULL value when $operation = 1 or $operation = 3. how to resolve this.