SQLServer与Access常用SQL函数区别
程序员文章站
2022-05-17 07:52:59
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
上一篇： 你儿子考得不错了
下一篇： 我爸第一次对我妈这么好