Suppose we have tables A,B,C,D, and each of them has a column [date1] which we positively know is filled during insert with the getdate() function.
Is it safe to assume that if row R1 on some table has an earlier value than row R2, on the same or another table, then the insertion of R1 happened indeed before R2, leading to ability to debug code in triggers, procedures etc?
It seems obvious, but one can never be sure enough. In contrast, the definition for rowversion seems more concrete about this.
For the sake of this question, I am not including updates, but feel free to expand.