读书人

帮忙把一句sql求id最大值转换成access

发布时间: 2013-10-30 12:56:21 作者: rapoo

帮忙把一句sql求id最大值转换成access
帮忙把sql转换成access
SQL:select isnull(max(ArticleId),0) as newIDValue from Article
ACCESS:?
[解决办法]
try this,


select iif(isnull(max(ArticleId)),0,max(ArticleId)) as newIDValue from Article

读书人网 >SQL Server

热点推荐