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 ?