SQLServer与Access常用SQL函数区别

2020-04-11 分类：SQLServer

标签Tags:sqlserver,access,常用,sql,函数,区别,case,when,iif,substring,mid,isnull,null,select,state,statetag,leave,order,id

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

以上就是【SQLServer与Access常用SQL函数区别】的全部内容了,欢迎留言评论进行交流!

SQLServer与Access常用SQL函数区别

与本文相关的软件

最新评论