CASE WHEN语句语法错误求助：SQL Server表字段更新问题

Let's break down what's causing your errors and fix the query:

The Issues in Your Original Code #

1. Unclosed Quotation Mark: The last value in your IN list ('000999鈥�') has a mangled character instead of a proper closing single quote. This is the primary cause of the Unclosed quotation mark error.
2. Parser Confusion: Because of the unclosed quote, the SQL parser got confused and threw a secondary error about the WHERE keyword (even though you don't have one in your query)—this is just a side effect of the first issue.

Corrected SQL Query #

Here's the fixed version that does exactly what you need:

UPDATE [dbo.industry]
SET areatype = CASE
    WHEN area IN ('000995', '000996', '000998', '000999') THEN '07'
    ELSE '04'
END;

Key Notes #

• This query updates every row in the table: rows where area matches any of the four values get areatype = '07', all others get areatype = '04'—which aligns perfectly with your requirement.
• I removed unnecessary parentheses around the CASE expression and WHEN condition to clean up the code, but those wouldn't have caused errors on their own.
• Since areatype is a char(2) and area is char(6), the string values ('07', '04', and the area codes) are properly sized for their respective columns.

内容的提问来源于stack exchange，提问作者Calflamesfann