SQLServer與Access常用SQL函數區別

SQLServer Access
CASE...WHEN... IIF()
SUBSTRING() MID()
ISNULL() IIF(IS NULL)

SELECT *,IIf([State]=1,'√','×') as StateTag FROM Leave order by id desc

SELECT IIf([CateID] = 1, "文檔"),IIf([CateID] = 2, "視頻"),IIf([CateID] = 3, "音頻") FROM File