简介:sqlServerAccessCASE.WHEN.IIF()SUBSTRING()MID()ISNULL()IIF(ISNULL)sqlServer:select*from[user]wherecast(right(RTrim(ID),4)asinteger)1234select*from[user]whereconv。
sqlServer Access
CASE.WHEN.IIF()
SUBSTRING() MID()
ISNULL()IIF(IS NULL)
sqlServer:
select * from [user] where cast(right(RTrim(ID),4) as integer)1234
select * from [user] where convert(integer,right(RTrim(ID),4))1234
select (case Sex when 1 then 男 when 0 then 女 else null end) as Sex from [User]
ACCESS:
SELECT *,IIf([State]=1,√,×) as StateTag FROM Leave order by id desc
SELECT IIf([CateID] = 1,”文档”),IIf([CateID] = 2,”视频”),IIf([CateID] = 3,”音频”) FROM File
home page http://blog.csdn.net/cadenza7
总结
以上是为你收集整理的SQLServer VS Access常用SQL函数区别全部内容,希望文章能够帮你解决SQLServer VS Access常用SQL函数区别所遇到的程序开发问题。