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