急！！急!!急!!菜鸟在线等一个简单的sql

alphao0

select  sum(DocCount) as DocCount,
MAX(convert (int,SignSendDate))as CompleteDate from ArchiveInfos
where docID in( select DocID from DocArchiveItems where InfoID='00000000000000000019') and sourcetype='1'

   怎样 当docCount 为null的时候 让doccount=0，不是null 时候 等于所求的和

cv4bf5d65fd

select  sum(isnull(DocCount,0)) as DocCount,
MAX(convert (int,SignSendDate))as CompleteDate from ArchiveInfos
where docID in( select DocID from DocArchiveItems where InfoID='00000000000000000019') and sourcetype='1'

cv4bf5d65fd

isnull(列名,0)这样就可以了

alphao0

我是判断 sum后的那个字段的值 isnull好像不行啊

alphao0

刚才写错了 晕 呵呵 谢谢了

恶魔右指

select  sum(DocCount) as DocCount
换一下
select DocCount=case when sum(DocCount)!=0 then sum(DocCount) else ''end