0 votes
1 view
in SQL by (20.3k points)

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

1 Answer

0 votes
by (40.3k points)

Try this code.

Query:

Update myTable set MyColumn = NULL

The above query will set the entire column to null as per the question's title (i.e. To set a column value to NULL in SQL Server Management Studio).

You can use this query, to set the specific row on a specific column to null this way:

Update myTable set MyColumn = NULL where Field = Condition.

Here, the above code will set the specific cell to null as per the inner question (i.e. To clear the value from a cell and make it NULL).

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...