How to insert current date in row's column

Question

How do I insert current date into a row's column in the "Edit data" view in MS SqlServer Mgm Studio? I want to get the equivalent value of GetDate() function call.

Here's an image which I hope clarifies the question:

Answer 1

you can not type function so type the date or one of following solution

• Create a default GetDate() on the modificationddate column on your table.
• Create a update trigger that update modificationddate column when data changes in the row.