T-SQL修改相同字段不同记录的语句

--下面是更新Sys_SysData表中SubName字段的Acode、AName
UPDATE Sys_SysData SET SubValue = CASE SubName 
WHEN 'ACode' THEN @Acode 
WHEN 'AName' THEN @AName 
WHEN 'ProductType' THEN @ProductTag END 
WHERE SubName IN ('ACode','AName','ProductType')