Skip to content Skip to sidebar Skip to footer

How To Insert Current Date In Row's Column

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

Solution 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.

Post a Comment for "How To Insert Current Date In Row's Column"