Setting a column to null in the Enterprise Manager | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Setting a column to null in the Enterprise Manager


I am trying to figure out how to set a column to null usin the Enterprise manager (EM).
In other words, when I right click on a table in the EM, and I open all rows, I can edit the table at this point. I need to make the contents of a particular column null.
I used to do this with some escape sequence, like Control "n" or something, but I can’t remember what it is. Does anyone know? Thanks.
you can press ctrl+0 to insert a NULL value
It is better to do it in QA than EM. Becuase if there are identical rows, you will get error Update table yourTable set col=null where <Some Condition>
Madhivanan Failing to plan is Planning to fail
True, you may get into trouble if the table rows are more and databsae may be unresponsive for a while using thru enterprise manager. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>