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
如对本文有疑问,
点击进行留言回复!!
相关文章:
-
-
-
-
-
-
-
实时流式计算系统中的几个陷阱
随着诸如Apache Flink,Apache Spark,Apache Storm之类的开源框架以及诸如Google Dataflow之类的云框架的增...
[阅读全文]
-
-
-
-
网友评论