博闻精思 物我一体

Set Null value to a cell in SQL table

If you have the table opened and you are in the cell, type

“Ctrl + 0″

that should set the value back to null. If you're running scripts in SQL Query Analyzer than run a simple script something like this

begin tran
update MyTable
set MyCell = null
where uniqueid = YourUniqueId

pay close attention to YourUniqueId otherwise you will update the entire table than I would run a select to check that the data is correct

select MyCell from MyTable where uniqueid = YourUniqueId

if the data is correct than run script

commit tran

otherwise run

rollback tran