troubleshooting Question
SQL Server - Column Update
asked on
Hello All,
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
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
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 8 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.