SQLServer与Access常用SQL函数区别
数据库 发布日期：2024/10/7 浏览次数：1
正在浏览：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