作废大于日期的订货单

wbv123

select * from u_indent_m where status=0 and createtime<‘2019-10-01’

create table #disable_u_indent_m(id int)
update u_indent_m set status=2 where status=0 and createtime<‘2019-10-01’

drop table #disable_u_indent_m