In SSMS, when editing a row of data in a table, you can press Ctrl+0 to enter a null in the current cell. Is there any shortcut for entering the current date in a cell?
...but if you are still allowing nulls, you have to delete `NULL` from the column.
Jay
2010-01-26 21:31:30
That hotkey is Ctrl+9, but you can make it anything you want. ^ for ctrl, ! for alt, and + for shift. {F1} etc. for function keys.
Jay
2010-01-26 21:48:57
A:
This page http://msdn.microsoft.com/en-us/library/ms175917.aspx has the shortcut documentation for the SQL Table Editor.
Under "Results Pane" it specifies the available shortcuts including "Enter null into a cell: CTRL+0". There are no other shortcuts listed that would do what you wish, so I would say you're out of luck with any easy out of the box trick.
eddiegroves
2010-01-26 21:39:27