CASE statement in UPDATE SQL Server

We can use CASE statement with UPDATE command in SQL Server.
We have following records in table.



Let’s try to update tables with case statement.

T-SQL:

DECLARE @TableUpdateCase TABLE
(Department VARCHAR(30),SalaryPercent INT)
INSERT INTO @TableUpdateCase
SELECT 'IT',60 UNION ALL
SELECT 'HR',20 UNION ALL
SELECT 'TECH',40 UNION ALL
SELECT 'ACCOUNT',30 UNION ALL
SELECT 'ADMIN',40 UNION ALL
SELECT 'SALES',80 
UPDATE  @TableUpdateCase
SET
SalaryPercent = SalaryPercent + 
		CASE 
		WHEN Department = 'IT' THEN 5
		WHEN Department = 'HR' THEN 4
		WHEN Department = 'TECH' THEN 9
		WHEN Department = 'ACCOUNT' THEN 7	
		WHEN Department = 'ADMIN' THEN 9
		WHEN Department = 'SALES' THEN 8		
		END
SELECT * FROM @TableUpdateCase

After UPDATE table status has become:



That’s It.
Enjoy Learning.