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
原创文章，作者：306829225，如若转载，请注明出处：https://blog.ytso.com/tech/database/236600.html