我想在SQL中将NULL值替换为0 [英] I want to replace the NULL value to 0 in SQL
问题描述
我想得到输出有0代替NULL值
这是存储过程
选择*来自GRPS.dbo.PEChartData
选择强制转换(最大值(PB12m)为十进制(10,2))为MaxData,强制转换(最小值(PB12m)) as decimal(10,2))作为来自GRPS.dbo.PEChartData的MinData
where convert(datetime,[Price Date],102)> DATEADD(年, - @ iNoYr,GETDATE())
和Code = @ code
输出 -
MaxData MinData
NULL NULL
什么我试过了:
SELECT ISNULL(myColumn,0)FROM myTable
SELECT ISNULL(施放(最大(PB12m)为十进制(10,2))为MaxData,0)FROM GRPS .dbo.PEChartData
但这是错误
关键字'as'附近的语法不正确。
请帮助
isnull (cast(max(PB12m)as decimal(10,2)),0)as MaxData
选择列名称错误地方。
尝试:
SELECT ISNULL(施放(最大(PB12m)为十进制(10,2)),0)AS MaxData FROM GRPS .dbo.PEChartData
I want to get Output has 0 in place of NULL Value
This is the Store Proc
select * from GRPS.dbo.PEChartData
select cast(max(PB12m) as decimal(10,2)) as MaxData , cast( min(PB12m)as decimal(10,2)) as MinData from GRPS.dbo.PEChartData
where convert(datetime,[Price Date],102) > DATEADD(year ,-@iNoYr,GETDATE())
and Code=@code
output-
MaxData MinData NULL NULL
What I have tried:
SELECT ISNULL(myColumn, 0 ) FROM myTable
SELECT ISNULL(cast(max(PB12m) as decimal(10,2)) as MaxData , 0 ) FROM GRPS.dbo.PEChartData
But this is getting Error
Incorrect syntax near the keyword 'as'.
Kindly help
isnull (cast(max(PB12m) as decimal(10,2)),0) as MaxData
The selection column name is in the wrong place.
Try:
SELECT ISNULL(cast(max(PB12m) as decimal(10,2)), 0 ) AS MaxData FROM GRPS.dbo.PEChartData
这篇关于我想在SQL中将NULL值替换为0的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!