Let’s say you are viewing results in Enterprise Manager or the SQL Server Management Tools and you really want to update a cell will a NULL value. Sure you could script it. Heck, you’re welcome to wrap the one line script in a Transaction and produce a rollback script as well if you’d like. But, if you are lazy like me, you just want to update the value using tools, all reckless-like. The trick is to select into the cell and press the lucky CTRL + 0 key combo. That’s a zero, by the way. I also go for CTRL + DEL, and then wonder why NULL doesn’t magically appear. Hence the post.
May 15th, 2009 at 11:08 am
You can also type the word NULL in all capital letters, I use that all the time.
May 19th, 2009 at 7:31 am
@Eric - Thanks for the comment. You’re right. Typing NULL works in SSMS. I’m pretty sure it didn’t/doesn’t work with SQL Enterprise Manager though.