NULL value for int in Update statement

Question

Is it possible to set NULL value for int column in update statement   How can I write the update statement in this case

User · Answer

By using NULL  without any quotes   UPDATE  tablename  SET  fieldName    NULL

User · Answer

If this is nullable int field then yes   update TableName set FiledName   null where Id   SomeId

User · Answer

Provided that your int column is nullable  you may write   UPDATE dbo TableName SET TableName IntColumn   NULL WHERE  lt condition gt

User · Answer

Assuming the column is set to support NULL as a value   UPDATE YOUR TABLE    SET column   NULL   Be aware of the database NULL handling - by default in SQL Server  NULL is an INT   So if the column is a different data type you need to CAST CONVERT NULL to the proper data type   UPDATE YOUR TABLE    SET column   CAST NULL AS DATETIME       assuming column is a DATETIME data type in the example above

[sql] NULL value for int in Update statement

Examples related to sql

Examples related to sql-update