Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Using UNPIVOT with CDC Functions to get Updated Columns List if Change Data Capture (CDC) is enabled DML statements (insert/update/delete) to a table are captured. The function cdc.fn_cdc_get_all_changes_ can be used to query changes made to the table.
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.