/*当库存表有一个商品的名称要修改时,请实现只写一条修改库存表的语句,
实现所有数据的修改(这里只包括进货表和销售表达式):使用<触发器>*/
ALTER TRIGGER [abc]
ON [dbo].[JH]
FOR INSERT
AS
BEGIN
DECLARE @GOODID INT
declare @sl int
SELECT @GOODID=INSERTED.GOODID FROM INSERTED
select @sl=sl from inserted
IF EXISTS (SELECT GOODID FROM KC WHERE KC.GOODID=@GOODID)
BEGIN
UPDATE KC SET TOTAL=TOTAL+@sl WHERE KC.GOODID=@GOODID
END
ELSE
BEGIN
insert into KC select Goodid,GoodName,SL,GETDATE() as Date,Memo from jh where jh.goodid=@goodid
END
END