检查Null或Zeroes的数据集

I have a table with 10 columns of floating values associated to a Serial Number. Values can be entered or not in each column. 0 [zero] and NULL are not valid values. Using SQL SERVER 2012.I have a table with 10 columns of floating valu