SQL Server: Use a CASE Expression in an Update Statement ...

We can use various DML statements like INSERT, SELECT, DELETE and UPDATE with a CASE statement. ... If it is NULL, then update the value with the sal column of the employee ...

www.tech-recipes.com