How do I set a column value to NULL in SQL Server Management Studio?

sql sql-server ssms
Zack Peterson picture Zack Peterson · Jan 14, 2009 · Viewed 922.4k times · Source

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

Answer

Jeff Martin picture Jeff Martin · Jan 14, 2009

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.

Related questions

Insert Data Into Temp Table with Query

I have an existing query that outputs current data, and I would like to insert it into a Temp table, but am having some issues doing so. Would anybody have some insight on how to do this? Here is an …

Read More
SQL Server 2008: how do I grant privileges to a username?

I need to be able to establish an ODBC connection through SQL Server authentication. In SSMS how do I grant permission for a user to be able to have ALL RIGHTS on a specific database? is there a way to …

Read More
How to quickly edit values in table in SQL Server Management Studio?

Aside from context menu -> "Edit Top 200 Rows" from Object Explorer, is there a quick way to open a table in Edit mode where I can just quickly modify the value of a cell? I need to be able …

Read More