27,579
社区成员
发帖
与我相关
我的任务
分享
select min(ArticleSubTypeID) as num from ArticleSubType where ArticleTypeID='20' --返回 null
我想让查询结果为null的时候,变成0。
但是当我使用case when 语句时,提示无法将Nvarchar转换成int类型,因为返回的null。
可是当我转换成int类型时,就直接查询不出结果了,怎么办呢?
select (case Convert(int,ArticleSubTypeID)when '' then '0' else '1' end) as aa
from ArticleSubType where ArticleTypeID='20' --没有结果
怎么办呢????
select min(isnull(ArticleSubTypeID,'')) as num from ArticleSubType where ArticleTypeID='20'
--或是
select min(isnull(ArticleSubTypeID,0)) as num from ArticleSubType where ArticleTypeID='20'
select ISNULL(min(ArticleSubTypeID),0) as num from ArticleSubType where ArticleTypeID='20'