如何使用用例，当使用update查询时
如何使用用例，当使用update查询时
提问于 2018-05-29 05:46:53
第一种情况将在查询中编译，但当我添加第二种情况时，下面的错误显示“‘program’附近的语法不正确”。如何为update中的IN子句使用list。2008r
academic_session = CASE PC.KEY5
WHEN 'AGS' THEN 'AGS'
WHEN 'TRD' THEN 'Traditional'
END,
program = CASE PC.KEY3
WHEN PC.KEY3 IN ('FF-AGS', 'FF-TRD', 'TR-AGS', 'CH-TRD', 'CO-TRD', 'RE-TRD', 'TR-TRD', 'WDVW') THEN 'Undergraduate'
WHEN PC.KEY3 = 'CROSS' THEN 'CROSS'
WHEN PC.KEY3 = 'GR-AGS' THEN 'Graduate'
WHEN PC.KEY3 IN ('ND-AGS', 'ND-TRD') THEN 'Non Degree Seeking'
END program,“program”附近的语法不正确。
在单独的行上发布每个条件，它将进行编译。
program = CASE PC.KEY3
--WHEN PC.KEY3 IN ('FF-AGS', 'FF-TRD', 'TR-AGS', 'CH-TRD', 'CO-TRD', 'RE-TRD', 'TR-TRD', 'WDVW') THEN 'Undergraduate' --"Incorrect syntax near the keyword 'IN'"
WHEN 'FF-AGS' THEN 'Undergraduate'
WHEN 'FF-TRD' THEN 'Undergraduate'
WHEN 'TR-AGS' THEN 'Undergraduate'
WHEN 'CH-TRD' THEN 'Undergraduate'
WHEN 'CO-TRD' THEN 'Undergraduate'
WHEN 'RE-TRD' THEN 'Undergraduate'
WHEN 'TR-TRD' THEN 'Undergraduate'
WHEN 'WDVW' THEN 'Undergraduate'
WHEN 'CROSS' THEN 'CROSS'
WHEN 'GR-AGS' THEN 'Graduate'
WHEN 'ND-AGS' THEN 'Non Degree Seeking'
WHEN 'ND-TRD' THEN 'Non Degree Seeking'
END,回答 1
Stack Overflow用户
回答已采纳
发布于 2018-05-29 05:50:10
请在下面尝试
academic_session = CASE PC.KEY5
WHEN 'AGS' THEN 'AGS'
WHEN 'TRD' THEN 'Traditional'
ELSE NULL
END,
program = CASE WHEN PC.KEY3 IN ('FF-AGS', 'FF-TRD', 'TR-AGS', 'CH-TRD', 'CO-TRD', 'RE-TRD', 'TR-TRD', 'WDVW') THEN 'Undergraduate'
CASE WHEN PC.KEY3 = 'CROSS' THEN 'CROSS'
CASE WHEN PC.KEY3 = 'GR-AGS' THEN 'Graduate'
CASE WHEN PC.KEY3 IN ('ND-AGS', 'ND-TRD') THEN 'Non Degree Seeking'
ELSE NULL
END ,页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/50573740
复制相关文章
相似问题
腾讯云开发者
