SQL SERVER||Update multiple columns in SQL by using CASE statement

preview_player
Показать описание
Below is the example of updating multiple columns.
1. Update without CASE Statement
UPDATE [ICCTest_tbl]
SET RUNS=10504, Country_Name = 'England'
WHERE Player_Rank=1

2.Update with CASE Statement
UPDATE [ICCTest_tbl]
SET RUNS= CASE Player_Rank
WHEN 1 THEN 10504
WHEN 2 THEN 2539
WHEN 3 THEN 3122
WHEN 4 THEN 8161
WHEN 5 THEN 2123
WHEN 6 THEN 7368
WHEN 7 THEN 3775
WHEN 8 THEN 6023
WHEN 9 THEN 3137
WHEN 10 THEN 5482
END,
Country_Name = CASE Player_Rank
WHEN 1 THEN 'England'
WHEN 2 THEN 'Australia'
WHEN 3 THEN 'Pakistan'
WHEN 4 THEN 'Australia'
WHEN 5 THEN 'India'
WHEN 6 THEN 'New Zealand'
WHEN 7 THEN 'Australia'
WHEN 8 THEN 'Sri Lanka'
WHEN 9 THEN 'India'
WHEN 10 THEN 'England'
END
WHERE Player_Rank IN(1,2,3,4,5,6,7,8,9,10)
Рекомендации по теме