sql server update where null code example

Example 1: sql server update to null

Update myTable set MyColumn = NULL

Example 2: can you update NULL in sql

UPDATE [table]
SET [column]=0
WHERE [column] IS NULL;