我有一个代码:
DECLARE @a char(4)
Select @a=field_name
FROM table_name
where field='abc'
CASE @a
WHEN '2016' THEN
SELECT 'YES'
ELSE
SELECT 'No'
END CASE
错误为:
关键字"CASE"附近语法不正确
问题出在哪里?
这适用于MSSQL:
DECLARE @a char(4)
Select @a=field_name
FROM table_name
where field='abc'
IF @a = '2016'
SELECT 'YES'
ELSE
SELECT 'No'
或者使用这个:
SELECT
CASE WHEN field_name = '2016' THEN 'YES' ELSE 'No' END
FROM table_name
WHERE field='abc'