Let’s say we have a table Employees with a field Time and we want to update all Null fiels to 0
This the right statement to identify and update null values in a query.
Update Employees
set Time=0
where Time is null
K-Smart, IT Business Solutions
Find ideas to implement your IT enviroment
Let’s say we have a table Employees with a field Time and we want to update all Null fiels to 0
This the right statement to identify and update null values in a query.
Update Employees
set Time=0
where Time is null