Câu lệnh SQL

Ngày đăng: 13:40:32 02-12-2020

SELECT [DateAndTime]

      ,[Millitm]

      ,[TagIndex]

      ,[Val]

      ,[Status]

      ,[Marker]

  FROM [DATALOG_DATABASE].[dbo].[FloatTable]

  WHERE [DateAndTime] > '2020-12-01'

SELECT Report_Storage.DateAndTime, Report_Storage.TEMP_CS_F1_E131, Report_Storage.TEMP_CS_F1_E132, Report_Storage.TEMP_CS_F2_E141, Report_Storage.TEMP_CS_C1_E151, Report_Storage.TEMP_CS_C1_E152, Report_Storage.TEMP_CS_CH1_E161, Report_Storage.TEMP_CS_CH1_E162, Report_Storage.TEMP_ABF_E171, Report_Storage.TEMP_ABF_E172, Report_Storage.TEMP_PROCESSING_ROOM_P3_PROBE1, Report_Storage.TEMP_PROCESSING_ROOM_P3_PROBE2, Report_Storage.TEMP_PROCESSING_ROOM_P3_PROBE3, Report_Storage.TEMP_CHILL_ROOM_P4, Report_Storage.TEMP_DELIVERY_ROOM_P1

FROM DATALOG_DATABASE.dbo.Report_Storage Report_Storage

WHERE Report_Storage.DateAndTime BETWEEN ? AND ?