Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table that each once in a while we add a new column, i cannot keep adding columns one by one putting that if( isnull(), 0, column) as column
i want to turn it to do it dynamically for all the columns of the table whenever there is null value replace it with 0
How?
Hello,
NullAsValue *;
SET NullValue='0';
regards,