下面是我写的。。。但是不对。。求解
CREATE TRIGGER In_Filling
ON BG_Filling
FOR INSERT AS
DECLARE @S_fno INT,@S_eno INT, @S_ceo INT
SELECT @S_ceo = f_FEflag FROM INSERTED
SELECT @S_fno= t_count FROM BG_Trigger WHERE t_id = '1'
SELECT @S_eno= t_count FROM BG_Trigger WHERE t_id = '2'
IF (@S_ceo = '0')
BEGIN
ROLLBACK TRANSACTION
@S_fno = @S_fno+1
UPDATE BG_Trigger SET t_count = @S_fno WHERE t_id = '1'
END
IF (@S_ceo = '1')
BEGIN
ROLLBACK TRANSACTION
@S_eno = @S_eno+1
UPDATE BG_Trigger SET t_count = @S_eno WHERE t_id = '2'
END
自己解决了。但还是谢谢各位,给第一位了。。
CREATE TRIGGER [Ins_Filling] ON [dbo].[BG_Filling]
FOR INSERT
AS
DECLARE @S_fno INT,@S_eno INT, @S_ceo INT
SELECT @S_ceo = f_FEflag FROM INSERTED
if (@S_ceo = '0')
BEGIN
UPDATE BG_Trigger SET t_count = t_count + 1 WHERE t_id = '1'
END
if (@S_ceo = '1')
BEGIN
UPDATE BG_Trigger SET t_count = t_count + 1 WHERE t_id = '2'
END