Store procedure returned null value
I have problem on stored procedure after executing it
This is the select statement inside the stored procedure:
select sum(amt) as total from orders where order_Date = today
The problem occurs when there is no record or orders on a specific date.
How could I check if the value returned is null or there is no record found in vb.net?
Hope someone could help me on this. Thanks!!!
# 1 Re: Store procedure returned null value
2 solutions:
in SQL (Ms SQL) for example:
SELECT IsNUll((select sum(amt) as total from orders where order_Date = today),0)
in VB use .IsNull (as I remember) method of DataReader or DataTable
Krzemo at 2007-11-10 3:30:57 >
# 2 Re: Store procedure returned null value
SQL Server 2000
SELECT COALESCE(sum(amt),0) as total from orders where order_Date = today
ddrib at 2007-11-10 3:31:57 >
