欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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