您的表只包含整数字段，您在Update语句中输入字符值。这是绝对错误的。



将表格列数据类型更改为 varchar 或 nvarchar 然后只有你可以在列中输入 - 值。



谢谢

Hi,

Your table contains only integer fields and you are entering the character value in the Update statement. This is absolutely wrong.

Change your table column datatypes to varchar or nvarchar then only you can enter the "-" value in your columns.

Thanks

试试：

Try:

UPDATE P1
SET 
  P1.Test1= CASE WHEN P1.Test1 IS NULL THEN '-' ELSE P1.Test1 END 
, P1.Test2= CASE WHEN P1.Test2 IS NULL THEN '-' ELSE P1.Test2 END 
, P1.Test3= CASE WHEN P1.Test3 IS NULL THEN '-' ELSE P1.Test3 END 
 
FROM SampleTable1 AS P1
WHERE P1.Test1 IS NULL OR P1.Test2 IS NULL OR P1.Test3 IS NULL

>