SQLblog.com - The SQL Server blog spot on the web
How the rowversion datatype works when adding and deleting columns
For years, I had thought (and was probably taught in SQL.AlongTimeAgoInAPlaceFarFarAway) that the timestamp column (well before rowversion was a thing,) was not guaranteed to be an ever increasing value. But this is not the case. In BOL ( https://docs.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql ) it states: "The rowversion data type is just an incrementing number..." This makes it useful for determining rows that have changed,...(read more)
No comments:
Post a Comment