Introduction
Very Often while working with data, our requirement is to retrieve which data has been modified and keep to data in two tables in synchronized. For achieving this task SQL Server has provided many way such as CDC (Change Data Capture), rowversion datatype, MERGE statement and various other alternatives using such as joins , storing datetime etc, which can be used based on our requirement.
Here, we will discuss about rowversion datatype and see a small demo how we use rowversion to Sync data changes done in a table to other table.
