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