SQLServer与Access常用SQL函数区别
程序员文章站
2022-11-21 11:14:32
sqlserver access case...when... iif() substring() mid() isnull() iif(is null) select *...
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
上一篇： MYSQL 导入数据的几种不同
下一篇： PHP实现多个关键词搜索查询功能示例