SQLServer VS Access常用SQL函数区别

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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!