—修改零售主表
update aa set accdate=’2021-01-12′,
starttime=’2021-01-12 17:25:27.500′,
finaltime=’2021-01-12 17:25:24.280′
from u_sale_m aa where saleno=’21011901160235′ –修改明细表 create table #disable_u_sale_c(id int)
update aa set accdate=’2021-01-12′
from u_sale_c aa where saleno=’21011901160235′
drop table #disable_u_sale_c
|