Guest User

Untitled

a guest
Apr 25th, 2018
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.59 KB | None | 0 0
  1. CROSS JOIN (
  2. SELECT cols.column_id
  3. FROM [sys].[columns] AS cols WITH (NOLOCK)
  4. WHERE cols.object_id = OBJECT_ID('dbo.MyHistoryTable')
  5. AND cols.name IN (
  6. 'Col1',
  7. 'Col2',
  8. 'Col3',
  9. 'Col4',
  10. 'Col5',
  11. 'Col6',
  12. )
  13. ) AS cols
  14.  
  15. IF EXISTS (
  16. SELECT 1
  17. FROM dbo.MyHistoryTable WITH (NOLOCK)
  18. RIGHT JOIN SomeThing AS ct ON [MyHistoryTable].[MyHistoryTablePK] = ct.[MyHistoryTablePK]
  19. CROSS JOIN (
  20. SELECT cols.column_id
  21. FROM [sys].[columns] AS cols WITH (NOLOCK)
  22. WHERE cols.object_id = OBJECT_ID('dbo.MyHistoryTable')
  23. AND cols.name IN (
  24. 'Col1',
  25. 'Col2',
  26. 'Col3',
  27. 'Col4',
  28. 'Col5',
  29. 'Col6',
  30. )
  31. ) AS cols
  32. WHERE (
  33. ct.SYS_CHANGE_CONTEXT IS NULL
  34. OR ct.SYS_CHANGE_CONTEXT <> CONVERT(VARBINARY(128), @someVarHere)
  35. )
  36. AND CHANGE_TRACKING_IS_COLUMN_IN_MASK(cols.column_id, ct.SYS_CHANGE_COLUMNS) = 1
  37. AND ct.SYS_CHANGE_OPERATION = 'U'
  38. AND (
  39. EXISTS (
  40. SELECT 1
  41. FROM dbo.[MyHistoryTable] AS t1 WITH (NOLOCK)
  42. INNER JOIN (
  43. SomeOtherStuffHere
  44. WHERE t1.MessagePK = [MyHistoryTable].MessagePK
  45. )
  46. )
  47. )
  48. SELECT @myVar = 1;
Add Comment
Please, Sign In to add comment