Geek asks and answers

How to insert current date in row column

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

Here's an image that I hope will clear up the question:

An image clarifying the question

+5
source share
1 answer

you cannot enter a function, so enter a date or one of the following solutions

  • Create a default GetDate()in the modifyddate column of your table.
  • Create an update trigger that updates the updateddate column when data changes in a row.
+4
source

More articles:


All Articles