数据库--sqlserver--sqlserver 查询 值如果为NULL则显示0-解决方法

方法1：

isnull(字段名称,0) as 字段名称

--字符型
select isnull(mycol,'0') as newid from mytable
--整型
select isnull(mycol,0) as newid from mytable

方法2：

columnName为字段名

case when columnName is null then 0 else columnName end

例如：

SELECT tt.start_date,
       tt.start_hour,
       tt.start_minute,
       tt.team_num,
       tt.count,
       tt.team_num_pk,
       CASE
         WHEN tt.countpk IS NULL THEN 0
         ELSE tt.countpk
       END
FROM   (SELECT start_date,
               start_hour,
               start_minute,
               team_num,
               (SELECT Sum(count) AS count
                FROM   t_world_cup_guess_transaction_m t
                WHERE  t.team_num = c.team_num
                       AND t.match_num = c.match_num) AS count,
               team_num_pk,
               (SELECT Sum(count) AS count
                FROM   t_world_cup_guess_transaction_m t
                WHERE  t.team_num = c.team_num_pk
                       AND t.match_num = c.match_num) AS countpk
        FROM  t_world_cup_guess_competition_process  c) tt