- declare @begin_date datetime
- declare @end_date datetime
- select @begin_date = getdate()
- SELECT TOP 1000 * FROM BEIYI_DEVICE_REPORT_RECORD_LOG WHERE DATEDIFF(DAY, drri_data_time, GETDATE()) >80
- select @end_date = getdate()
- select datediff(ms,@begin_date,@end_date) as '用时/毫秒'