Adding current date time in SQL Table using SSMS Edit Mode

Here’s something fairly quick and easy.

In a new query window execute the query, SELECT GETDATE().

Select the result in the result pane and ctrl-c to copy it to the clipboard.

Then go back to your Edit window, and paste into the datetime cell(s).