A.CHECK(销售价格BETWEEN单价*0.6 AND单价*1.5)
B.CHECK(销售价格BETWEEN商品表.单价*0.6 AND商品表.单价*1.5)
C.CREATE TRIGGER tri_Sales ON销售表FOR INSERT,UPDATE AS IF EXISTS(SELECT*FROM INSERTED a JOIN商品表b ON a.商品号=b.商品号 WHERE销售价格NOT BETWEEN单价*0.6 AND单价*1.5) ROLLBACK
D.CREATE TRIGGER tri_Sales ON销售表INSTEAD OF INSERT,UPDATE AS IF EXISTS(SELECT*FROM INSERTED a JOIN商品表b ON a.商品号=b.商品号 WHERE销售价格NOT BETWEEN单价*0.6 AND单价*1.5) ROLLBACK