Skip to content

Instantly share code, notes, and snippets.

@hsuyuming

hsuyuming/ct_table

Created August 22, 2019 17:07
Show Gist options
  • Save hsuyuming/708b93cc3f248abecaa4d09407737434 to your computer and use it in GitHub Desktop.
Save hsuyuming/708b93cc3f248abecaa4d09407737434 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ct_table
select mapping.tran_begin_time,mapping.tran_end_time,convert(decimal(19,0),src.__$seqval),src.*
from cdc.dbo_TEST_CT as src
inner join cdc.lsn_time_mapping as mapping
on src.__$start_lsn = mapping.start_lsn
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment