I have a SQL Server Question. I am not sure which the best way to do it is. Now the requirement:
Every time, a new row(s) is inserted to my table xyz, then there is column in that table, called [update time], that gets the time of update in the format below…
For example – server Table
col1 col2 col3 updateTime
dsas sdads sdad 12/04/2012 1.45 PM
dsas sdads sdad 12/04/2012 1.50 PM
Is this difficult to accomplish?
Thanks
R
Microsoft SQL ServerMicrosoft SQL Server 2008
Last Comment
Rayne
8/22/2022 - Mon
Rayne
ASKER
Also, [updateTime] column has to be of any specific format for achieving this?
If this is a date time column I recommend you to Insert the date time value with default format and while retrieving the values convert to the required format. This method has the advantage that you can do date manipulations to the date time column with out the requirement of any conversion and of-course the performance adv also.