Ted Zhang

关于Sharepoint及.NET的种种...
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

posted on 2013-06-15 19:41  Ted Zhang  阅读(187)  评论(3编辑  收藏  举报