SELECT CASE WHEN DATEDIFF(DD,TIME,GETDATE())>10 THEN 1 ELSE 0 END AS idtrue FROM TBUPDATE TB SET idtrue=CASE WHEN DATEDIFF(DD,TIME,GETDATE())>10 THEN 1 ELSE 0 END
update tb set idtrue=1 where datediff(dd,注册时间,getdate())>10
update [table] set idtrue=1 where datediff(day,[time],getdate())>10
where datediff(day, date_column, getdate())>10
update [table] set idtrue=1 where datediff(dd,注册时间,getdate())>10
tb
set
idtrue=1
where
datediff(dd,注册时间,getdate())>10
update [table] set idtrue=1 where datediff(day,[time],getdate())>10
where datediff(dd,注册时间,getdate())>10