Set Null value to a cell in SQL table
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
分类: MS SQL