问题描述:

There is a query:

UPDATE MyTable SET nvarchar1 = 'blahblah'

WHERE Id = '096fe792-7313-416f-b3c8-327f46be73b6' AND nvarchar1 <> 'blablah'

It doesn't work, when nvarchar1 is NULL. How should I change it to make it work?

  1. It is important to me don't execute update, if value has not been really changed.
  2. I don't know column type. It can be not only nvarchar, but ntext, integer or float-point number as well.

Regards,

网友答案:
UPDATE MyTable SET nvarchar1 = 'blahblah'
WHERE Id = '096fe792-7313-416f-b3c8-327f46be73b6' 
AND (nvarchar1 IS NULL 
OR nvarchar1 <> 'blablah')

Do you mean this?

网友答案:
UPDATE MyTable SET nvarchar1 = 'blahblah'
WHERE Id = '096fe792-7313-416f-b3c8-327f46be73b6' AND isnull(nvarchar1,'') <> 'blablah'
相关阅读:
Top