When using SQL Server Management Studio, sometimes (especially during testing phases) it becomes necessary to enter data manually. It’s easy when you actually want to enter text via specific datatypes, but what do you do when you want to force a field to null?

It turns out that accomplishing this feat is very simple. Just click inside the cell you want to enter a null value and use this shortcut:
Ctrl-0
(btw – that is not the letter ‘O’, but it is the number zero)
That’s all there is to it.