--按照日期删除流水
delete from xjl_Details where convert (char(8),tradetime,112) < '20251011' 
delete from xjl_nocashDetails where convert (char(8),tradetime,112) < '20251011' 
delete from xjl_total where convert (char(8),tradetime,112) < '20251011'

按照日期删除流水。日期可以修改。保留30天内就可以。