sql server - Implementing IF Condition Within a T-SQL UPDATE ...

Using T-SQL, I would like to execute an UPDATE statement that will SET columns only if the ... CASE WHEN LEN(@Password) > 0 THEN @Password ELSE Password END WHERE .

stackoverflow.com