TableMetadata.sql 368 B

12345678910
  1. IF NOT EXISTS (SELECT * FROM DataAccessLayer.TableMetaData WHERE TableName = 'Transaction')
  2. BEGIN
  3. INSERT DataAccessLayer.TableMetaData
  4. VALUES ('Transaction', '2020-01-01T00:00:00.000', NULL, 'Lower')
  5. End
  6. UPDATE md
  7. SET md.BoundaryDateTime = '2020-01-01T00:00:00.000', md.BoundaryType = 'Lower'
  8. FROM DataAccessLayer.TableMetaData md
  9. WHERE md.TableName = 'Transaction'