(这是一个虚构的例子,请忽略事务)首先,我们来看一个简化单据修改的例子,单据数据表结构如下:1. MOrder(id,remark,createtime)id:单号createtime:创建时间2. MOrderDetail (MOrderid,pku,qty)MOrderid:单号pku:商品编号qty:数量面对这个简单的需求,我们有第一版的SQLView Code update MOrder set remark=@remarkwhere id=@iddelete from MOrderDetailwhere MOrderid=@idinsert into MOrderDetail va. Read More
posted @ 2011-08-22 11:07 天空天下 Views(3467) Comments(1) Diggs(2) Edit