"="消息 102 附近的语法不正确，对此错误有什么想法吗？

Question

select name  ,surname,available_amount,
case 
when name=credit_account  then amount = amount+available_amount 
when name=debit_account   then amount = amount-available_amount 
else amount

end as available_balance

from accounts_table,transaction_table;

Answer 1

假设name是一个nvarchar/varchar，您在值

周围缺少引号。

when name='credit_account'

还有then部分的语法是错误的，应该是

then amount+available_amount