How to insert a NULL into SQL Server Management Studio

When doing a right-click >> Edit Top xxx Rows you may want to add a NULL value in an attribute sometime or another.
 

To do this you can:

• type CTL + 0 when in the column and a NULL will appear.
• Now the little-known and totally interesting one...type NULL in CAPS and you'll get a NULL in the column. Capital letters will appear, and then you are finished typing NULL the letters will turn into italics, letting you know that it's a NULL and not NULL. Sweet!

You'll only get these interesting factoids here at my blog - why look elsewhere?

Lee Everest

---------------

 Now you're asking - why the hell would you want to do this?