Procedure does not update table with NULL value

Question

Hello,

I have a little problem. I need my file to update a value that is inside a column in the table "Cashshopdata", at the moment my code is this way.

UPDATE CashShopData SET WCoinC=WCoinC+50 WHERE AccountID=@Account

I don’t know if it will be necessary to give a context to this line, but basically what is happening is that it doesn’t update the "Wcoinc=Wcoinc+50" because the value that is in the "Wcoinc" column is NULL. What I want to do is, if the value is NULL it will receive the value of 0, for that I would use an "IF", correct ?

-Exp: If Wcoinc value equals NULL then it equals 0

How do I translate this to SQL ?

I hope my doubts have been understandable, I await answers :)

Answer 1

You can use the function ISNULL in SQL Server, basically it returns an alternative value, when the value passed to it is null:

Example:

ISNULL(WCoinC, 0)

Use in your context:

UPDATE CashShopData SET WCoinC=ISNULL(WCoinC, 0)+50 WHERE AccountID=@Account

Another alternative would be the function COALESCE, which returns the first non-null value found in a list. This solution also works in other databases such as postgres, oracle, mysql...

Example:

COALESCE(WCoinC, WCoinD, WCoinE, 0)