I have a simple one for any database guys out there.
I have the fields isActive (bit) and Inactive_Date (datetime) in the table users.
I need a trigger to update the Inactive_Date field with CURDATE() when the field isActive is updated to 0 (False).
There are circumstances where this field would already be 0 but updated to the same value (during imports). I do not want Inactive_Date updated under these circumstances. It should only happen when the field changes from 1 to 0.
With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.