sql - 如何在SQL Server Management Studio中将列值设置为NULL？(How do I set a column value to NULL in SQL Server Management Studio?)

Question

如何清除单元格中的值并使其为NULL？

  ask by Zack Peterson translate from so

Answer 1

I think @Zack properly answered the question but just to cover all the bases:

(我认为@Zack正确回答了这个问题但只是为了涵盖所有基础：)

Update myTable set MyColumn = NULL

This would set the entire column to null as the Question Title asks.

(如问题标题所示，这会将整个列设置为null。)

To set a specific row on a specific column to null use:

(要将特定列上的特定行设置为null，请使用：)

Update myTable set MyColumn = NULL where Field = Condition.

This would set a specific cell to null as the inner question asks.

(当内部问题要求时，这会将特定单元格设置为null。)