Alter & Update Table with Null

select * from Prod

update Prod set Quantity=NULL where rowguid='D4544D7D-CAF5-46B3-AB22-5718DCC26B5E'

Alter table Prod alter column quantity smallint null