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"