首页 > 数据库 > Access > 正文

SQLServer与Access常用SQL函数区别

2020-10-29 21:54:15
字体:
来源:转载
供稿:网友
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
发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表