摘要: select v.Branch, v.Store, v.ChildId,SUM(r.Cash) from OrderDetail as r inner join Order as v on r.OrderId equals v.Id where r.OrderId == 123 group by v 阅读全文
posted @ 2022-01-18 17:40 清和时光 阅读(55) 评论(0) 推荐(0) 编辑
摘要: ###报错信息: Cannot insert explicit value for identity column in table 'Order' when IDENTITY_INSERT is set to OFF. ###分析: 报错解析:不能往Order表的自增字段插入值 通常情况下,不能向 阅读全文
posted @ 2022-01-18 11:52 清和时光 阅读(614) 评论(0) 推荐(0) 编辑