Το Στέκιου Γέλιου στο Facebook Twitter Email Google Plus
Breaking News
recent
SQL Server select and update null values in query

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

K-Smart

K-Smart

Powered by Blogger.