SQL Server Management Studio: Enter null values

Problem: You want to enter a null value into a field using the "Open Table" view.

Solution: Press Ctrl + 0 (zero) with the field highlighted.

Notes: I kept pressing Ctrl - O (oh) and getting nowhere. I believe all fonts should use slashed zeros to prevent confusion in this matter. Works in Management Studio and Enterprise Manager.

2 comments:

Anonymous said...

Thank you!
(Btw, your post no longer has "Oh" comments now ;) )

Commenter said...

Thanks! Found this on the top 5 Google hits for "management studio edit table enter null".

Impossible to find in MS Help of course.