SQL Server——Isnull() CAST()函数
SELECT isnull(Sum(CAST(DAY0 AS DECIMAL(8,2)) ),0) as DAYSALES from SMASTOREFORECASTINFOIsnull(): Sum(CAST(DAY0 AS DECIMAL(8,2)) )为NULL 时候 会把0赋值给DAYSALES CAST():CAST(DAY0 AS DECIMAL(8,2)) 将每天的DAY0 值最多...
原创
2018-02-09 22:51:41 ·
1994 阅读 ·
0 评论