判断记录是否存在和日期差操作

if (not exists(select 0 from [DownloadJobLog] where [JobName]=@JobName and (DATEDIFF(dd,[ImportDate],@ImportDate)=0)))
原文地址:https://www.cnblogs.com/ylemzhang/p/1678502.html