思迅软件知识库
| 【问】如何删除以往做过的所有特价菜品？ | ||
| 【适用版本】食通天5 | 【模块】基础资料 | 【点击数】64 |
| 【知识编号】C2012061100001 | ||
| 【问题描述】新增特价时提示重复，如何删除以往做过的所有特价菜品？ | ||
use issrestv5
go
delete from cybr_bt_dish_special where dt_begin>=’2011-01-01′ and dt_end <=’2012-05-30′
use issrestv5
go
delete from cybr_bt_dish_special where dt_begin>=’2011-01-01′ and dt_end <=’2012-05-30′