How Do I Set a Column Value to Null in Sql Server Management Studio?

Question

How do I clear the value from a cell and make it NULL?

Accepted Answer

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

Update myTable set MyColumn = NULL

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

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

Update myTable set MyColumn = NULL where Field = Condition.

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

Accepted Answer

If you've opened a table and you want to clear an existing value to NULL, click on the value, and press Ctrl+0.

Answer 3

If you are using the table interface you can type in NULL (all caps)

otherwise you can run an update statement where you could:

Update table set ColumnName = NULL where [Filter for record here]

Answer 4

Use This:

Update Table Set Column = CAST(NULL As Column Type) where Condition

Like This:

Update News Set Title = CAST(NULL As nvarchar(100)) Where ID = 50

Answer 5

Ctrl+0 or empty the value and hit enter.

Answer 6

CTRL+0 doesn't seem to work when connected to an Azure DB.

However, to create an empty string, you can always just hit 'anykey then delete' inside a cell.

6 Answers