`
backspace
  • 浏览: 137335 次
文章分类
社区版块
存档分类
最新评论

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
分享到:
评论

相关推荐

    微软内部资料-SQL性能优化5

     If the table has a clustered index, the bookmark is the clustered index key for the corresponding data row. This clustered key can be multiple column if the clustered index is composite, or is ...

    微软内部资料-SQL性能优化3

    In our example, if one transaction (T1) holds an exclusive lock at the table level, and another transaction (T2) holds an exclusive lock at the row level, each of the transactions believe they have ...

    JSP Simple Examples

    We use the if condition to check if the particular condition is true then it should perform a certain task, and if a particular condition is not true then it should do some other tasks. ...

    曲线拟合工具CurveExpert 1.0

    + If the current path was changed from CurveExpert, the help file was not found. Fixed. Nov. 9, 1995, v. 1.11 =========================================================================== New ...

    CE中文版-启点CE过NP中文.exe

    This lets you filter out code based on if it has been executed or not (Uses software breakpoints) Debugging: Added an option to chose if you wish to break on unexpected breakpoints, and if CE should ...

    WPTools.v6.29.1.Pro

    - If you plan to use DBWPRichText please check http://www.wpcubed.com/forum/viewtopic.php?p=3456 - The reader/writer receive their options through "FormatStrings" please see list at ...

    EhLib5.0.13 最新的ehlib源码

    order, columns width, sortmarkers, row height) in/from registry or ini file. Allows to show hint (ToolTips) for text that don't fit in the cell. Allows to export data to Text, Csv, HTML, RTF, XLS ...

    Delphi7.1 Update

    * When using RefreshRecord on a Memo or Blobfield and the field has been modified by another user, the blobsize of that field does not change if it is less than before (Quality Central 4676).* ...

    EhLib 6.3 Build 6.3.176 Russian version. Full source included.

    order, columns width, sortmarkers, row height) in/from registry or ini file. Allows to show hint (ToolTips) for text that don't fit in the cell. Allows to export data to Text, Csv, HTML, RTF, XLS ...

    BobBuilder_app

    Pages in a b+tree are usually implemented as a list or array of child pointers and so while finding and inserting a value is a O(log k) ...process actually has to move children around in the array or list...

Global site tag (gtag.js) - Google Analytics