Skip to content

Instantly share code, notes, and snippets.

@tdmitch

tdmitch/ct_isinmask.sql

Created January 4, 2021 18:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tdmitch/387092b1e091716cebef68f72c09ea05 to your computer and use it in GitHub Desktop.
Save tdmitch/387092b1e091716cebef68f72c09ea05 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ct_isinmask.sql
SELECT *
, CHANGE_TRACKING_IS_COLUMN_IN_MASK (COLUMNPROPERTY(OBJECT_ID('dbo.Emp'), 'LastName', 'ColumnId'), ct.SYS_CHANGE_COLUMNS) AS MiddleName_Changed
FROM CHANGETABLE(CHANGES dbo.Emp, @ver) AS ct
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment