쿼리문.txt 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'