Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2011-11-08 : 02:34:18
|
| Hi All,Is it possible to capture the column name and the data changed in that column in seperate column means old data and new changed data?T.I.A |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-08 : 07:00:50
|
quote:
Originally posted by under2811
Hi,I need this type of output in table.A B C Start Date End Date Changea 34 43 01/01/2009 06/08/2009 Nulla 34 44 06/09/2009 07/13/2009 C => 43 to 44a 41 46 07/14/2009 Null B =>34 to 41, C => 44 to 46T.I.A
this is typical case where you capture changes with audit triggersee an example script herehttp://www.nigelrivett.net/AuditTrailTrigger.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Data changed and column name capture