T-SQL: Using a CASE in an UPDATE statement to update ...

2011年1月28日 - UPDATE table SET (CASE (CONDITION) WHEN TRUE THEN ... The only way to do specifically what you're asking is to use dynamic SQL.

stackoverflow.com