SQLServer VS Access常用SQL函数区别

简介:sqlServerAccessCASE.WHEN.IIF()SUBSTRING()MID()ISNULL()IIF(ISNULL)sqlServer:select*from[user]wherecast(right(RTrim(ID),4)asinteger)1234select*from[user]whereconv

简介:sqlServerAccessCASE.WHEN.IIF()SUBSTRING()MID()ISNULL()IIF(ISNULL)sqlServer:select*from[user]wherecast(right(RTrim(ID),4)asinteger)1234select*from[user]whereconv。

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


总结

以上是为你收集整理的SQLServer VS Access常用SQL函数区别全部内容,希望文章能够帮你解决SQLServer VS Access常用SQL函数区别所遇到的程序开发问题。

0 条回复 A 作者 M 管理员
    所有的伟大,都源于一个勇敢的开始!
欢迎您,新朋友,感谢参与互动!欢迎您 {{author}},您在本站有{{commentsCount}}条评论