导读：SQLServer Access CASE...WHEN... IIF() SUBSTRING() MID() ISNULL() IIF(IS NULL) SELECT *,IIf([State]=1,'√','×'..
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
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
更多文章请关注《万象专栏》
转载请注明出处：https://www.wanxiangsucai.com/read/cv132809
话题推荐： #SQLServer#
#Access#
#SQL函数#