SQLServer与Access常用SQL函数区别
时间：2021-05-10 08:42:00|栏目：|点击： 次
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
上一篇：负数与二进制换转方法
栏 目：
下一篇：docker 容器上编译 go 程序提示找不到文件问题
本文标题：SQLServer与Access常用SQL函数区别
本文地址：http://www.codeinn.net/misctech/118225.html
