Using CASE in UPDATE

sample on price increases:

UPDATE ItemPrice
SET Price = Price *
  CASE ItemId
    WHEN 1 THEN 1.05
    WHEN 2 THEN 1.10
    WHEN 3 THEN 1.15
    ELSE 1.00
  END

Found a mistake? Have a question or improvement idea? Let me know.

CASE:

* CASE

* Use CASE to COUNT the number of rows in a column match a condition.

* Searched CASE in SELECT Matches a boolean expression

* CASE in a clause ORDER BY

* Shorthand CASE in SELECT

* Using CASE in UPDATE

* CASE use for NULL values ordered last

* CASE in ORDER BY clause to sort records by lowest value of 2 columns

Table Of Contents

0 Getting started with SQL

1 SELECT

2 JOIN

3 Example Databases and Tables

4 UPDATE

5 Indexes

6 CREATE TABLE

7 UNION, UNION ALL

8 ALTER TABLE

9 CASE

10 INSERT

11 Primary Keys

12 ORDER BY

13 GROUP BY

14 Filter results using WHERE and HAVING

15 Window Fnctions

16 Common Table Expressions

17 Views

18 LIKE operator

19 Functions Aggregate

20 DELETE

21 String Functions

22 Data Types

23 AND OR operators

24 Triggers

25 TRUNCATE

26 MERGE

27 Foreign Keys

28 Finding Duplicates on a Column Subset with Detail

29 Sequence

30 Comments

31 Subqueries

32 Execution blocks

33 Stored Procedures

34 DROP Table

35 Row number

36 Transactions

37 CREATE FUNCTION

38 SQL Group by vs. Distinct

39 Table Design

40 CROSS APPLY and OUTER APPLY

41 Synonyms

42 CREATE database

43 SKIP TAKE pagination

44 EXPLAIN and DESCRIBE

45 Information Schema

46 IN clause

47 NULL

48 SQL Injection

49 Cascading Delete

50 Order of Execution

51 DROP or DELETE database

52 EXCEPT

53 TRYCATCH

54 XML

55 GRANT and REVOKE

56 Functions ScalarSingle Row

57 Relational Algebra

58 EXISTS CLAUSE

59 Materialized Views

60 Functions Analytic

61 SQL CURSOR

62 Identifier

63 Clean Code in SQL

64 Contributors