Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CROSS JOIN (
- SELECT cols.column_id
- FROM [sys].[columns] AS cols WITH (NOLOCK)
- WHERE cols.object_id = OBJECT_ID('dbo.MyHistoryTable')
- AND cols.name IN (
- 'Col1',
- 'Col2',
- 'Col3',
- 'Col4',
- 'Col5',
- 'Col6',
- )
- ) AS cols
- IF EXISTS (
- SELECT 1
- FROM dbo.MyHistoryTable WITH (NOLOCK)
- RIGHT JOIN SomeThing AS ct ON [MyHistoryTable].[MyHistoryTablePK] = ct.[MyHistoryTablePK]
- CROSS JOIN (
- SELECT cols.column_id
- FROM [sys].[columns] AS cols WITH (NOLOCK)
- WHERE cols.object_id = OBJECT_ID('dbo.MyHistoryTable')
- AND cols.name IN (
- 'Col1',
- 'Col2',
- 'Col3',
- 'Col4',
- 'Col5',
- 'Col6',
- )
- ) AS cols
- WHERE (
- ct.SYS_CHANGE_CONTEXT IS NULL
- OR ct.SYS_CHANGE_CONTEXT <> CONVERT(VARBINARY(128), @someVarHere)
- )
- AND CHANGE_TRACKING_IS_COLUMN_IN_MASK(cols.column_id, ct.SYS_CHANGE_COLUMNS) = 1
- AND ct.SYS_CHANGE_OPERATION = 'U'
- AND (
- EXISTS (
- SELECT 1
- FROM dbo.[MyHistoryTable] AS t1 WITH (NOLOCK)
- INNER JOIN (
- SomeOtherStuffHere
- WHERE t1.MessagePK = [MyHistoryTable].MessagePK
- )
- )
- )
- SELECT @myVar = 1;
Add Comment
Please, Sign In to add comment