当前位置：首页 -> 基础 -> 数据库编程

Check if row or table content has changed

2014-11-24 11:10:13 · 作者: · 浏览: 0
标签: Check row table content has changed

Check if row or table content has changed
By using CHECKSUM and CHECKSUM_AGG function in SQL Server, we could easily notice that if anything has changed or not. 







-- Check Row:
SELECT CHECKSUM(*) 
FROM TableFoo
WHERE ID = 1;

-- Check Table:
SELECT CHECKSUM_AGG(CHECKSUM(*))
FROM TableFoo

Happy Coding Everyday~ 快乐编码，享受生活～