set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER TRIGGER [BTEMP_INS] on [dbo].[BTEMP]
AFTER INSERT AS
Declare
@TUID int,
@TMONEY int,
@TIFLAG char(1),
@TANAME varchar(20),
@ACOUNT INT,
@CMONEY INT
BEGIN
select @TUID = UID from inserted
select @TMONEY = AMONEY from inserted
select @TIFLAG=IFLAG from inserted
select @TANAME =ANAME from inserted
select @Acount=0
SELECT COUNT(*) AS ACOUNT, SUM(AMONEY) AS AMONEY
FROM ATEMP WHERE UID=@TUID
-- 여기서 카운트를 알아야 하는데 계속 카운트가 엉뚱한거로 들어가네요.. ㅠ.ㅠ;
if @ACOUNT<>0
BEGIN
select AMONEY AS CMONEY FROM ATEMP WHERE UID=@TUID
select @TMONEY=@CMONEY+@TMONEY
UPDATE ATEMP SET AMONEY =@CMONEY where UID=@TUID
END
ELSE IF @ACOUNT=0
BEGIN
INSERT INTO ATEMP(ANAME, AMONEY, IFLAG) VALUES(@TANAME,@TMONEY,@TIFLAG)
END
END |