CREATE TRIGGER Storagerecord_update
ON Sellrecord
FOR INSERT
AS
IF (select s.GOODSID
FROM Storagerecord s JOIN inserted i
ON s.GOODSID=i.GOODSID) >0
BEGIN
IF (s.NUMBER>=i.NUMBER)
UPDATE s SET s.NUMBER=s.NUMBER-1
FROM Storagerecord s INNER JOIN inserted i
ON s.GOODSID=i.GOODSID
END
ELSE
BEGIN
PRINT 'Transaction cannot be processed'
ROLLBACK TRANSACTION
ENDStoragerecord为商品库存表,Sellrecord为销售记录表
ON Sellrecord
FOR INSERT
AS
IF (select s.GOODSID
FROM Storagerecord s JOIN inserted i
ON s.GOODSID=i.GOODSID) >0
BEGIN
IF (s.NUMBER>=i.NUMBER)
UPDATE s SET s.NUMBER=s.NUMBER-1
FROM Storagerecord s INNER JOIN inserted i
ON s.GOODSID=i.GOODSID
END
ELSE
BEGIN
PRINT 'Transaction cannot be processed'
ROLLBACK TRANSACTION
ENDStoragerecord为商品库存表,Sellrecord为销售记录表
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货