a56dcfda80134d5d66e0dd7a06ecc66e7118e2b8.svn-base 424 B

123456789
  1. [CreatedDateTime] >= '2018-02-19 00:00' and [CreatedDateTime] <= '2018-02-20 00:00'
  2. SELECT *
  3. FROM [iBems].[dbo].[BemsMonitoringPointHistoryDaily]
  4. where [SiteId] =1 and [CreatedDateTime]>= '2018-02-19 00:00' and [CreatedDateTime] <= '2018-02-20 00:00'
  5. delete [iBems].[dbo].[BemsMonitoringPointHistoryDaily]
  6. where [SiteId] =1 and [CreatedDateTime]>= '2018-02-19 00:00' and [CreatedDateTime] <= '2018-02-20 00:00'