判断记录是否存在和日期差操作 if (not exists(select 0 from [DownloadJobLog] where [JobName]=@JobName and (DATEDIFF(dd,[ImportDate],@ImportDate)=0)))