Breaking News
recent

SQL Server select and update null values in query

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

Προμηθέας

Προμηθέας

Powered by Blogger.