alter table set column nullable code example

Example 1: sql server alter table column nullable

ALTER TABLE Customer
	ALTER COLUMN CustDesc NVARCHAR(MAX) NULL;

Example 2: update set table column to null

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