Sqlserver跟踪特定列中的更改 [英] Sqlserver to track the changes in the specific columns
本文介绍了Sqlserver跟踪特定列中的更改的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
您好专家!
如何跟踪更新时特定列中的更改。列结果显示前两个值和当前值?
谢谢
sameer
解决方案
更新记录时,
update tbl1 set colprev = colcurr ,colcurr = ' abc' 其中 colid = 1
快乐编码!
:)
您好Aarti,
感谢您的relpy!
如果我只需要查看受影响的行意味着插入值并且用户尝试更新记录。如何跟踪日期戳上最近100天的变化?
谢谢
sameer
Hello experts !
How to track changes in the specific column on update. The column results shows both values previous and current?
Thanks
sameer
解决方案
While updating record,
update tbl1 set colprev = colcurr, colcurr = 'abc' where colid=1
Happy Coding!
:)
Hi Aarti,
Thanks for your relpy !
if i need to see only a affected rows means when value is inserted and user try to update the record . How can i track those changes for last 100 days on date stamp?
Thanks
sameer
这篇关于Sqlserver跟踪特定列中的更改的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文