sql - Case SQL 语句中 IFF 的等效项

Question

我正在尝试将访问 IFF 查询转换为 SQL Server 查询

SELECT blah blah ,
    IIf([stock]![supplier]=[pos]![supplier],"Preferred"," ") AS Preferrednew 
FROM blah blah

在访问中，当条件为真时，这将在称为 Preferrednew 的列中给出首选值。

我已将代码转换为..

SELECT blah blah ,
 CASE WHEN ([stock.supplier] = [pos.supplier]), 'test', 'test2' AS [preferrednew]
FROM blah blah

但我收到错误

Incorrect syntax near ','

正确的格式是什么？

Answer 1

SELECT blah blah ,
    CASE WHEN stock.supplier = pos.supplier THEN 'test'
    ELSE 'test2'
    END AS [preferrednew]
FROM blah blah

请记住，SQL Server 2012+ 支持 IIF