Beginning SQL Server 2005 for Developers: From Novice to Professional
by Robin Dewson ISBN: 1-59059-588-2 536 pp. Source Code Table of Contents Sample Chapter: Ch. 04 - Security |
|
Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience. Free White Paper
Database Recovery
Feeling the increased demands on data protection and storage requirements? Download Free Report! |
Sponsored by:
Links to external sites are subject to change; DBAzine.com and BMC Software do not control or endorse the content of these external web sites, and are not responsible for their content. LEGAL STATEMENT © 2007 DBAzine.com. All Rights Reserved. |
In the section Using COLUMNS_UPDATED() the following code should read (the correction is the line of code)
Now if bits 2 and 4 are switched on within a byte, in other words, they have a setting of true (00010100), then the value is 4 + 16, which equates to 20. Therefore, to test whether the third and fifth columns of our table have BOTH been altered, we would use the following syntax:
IF COLUMNS_UPDATED() & 20 = 20