CREATEA TRIGGER TEST ON TABLEA FOR INSERT BDGINdeclare @i int select @i=id from inserted insert into table(字段) values(@i)END
--我这里没有考虑一次插入多条记录的情况,只考虑了一次插一条记录的情况(头很疼, --睡觉去了) CREATE TRIGGER insert_trigger ON a FOR INSERT AS BEGIN DECLARE @i int SELECT @i=xuhao FROM inserted IF @i=1 --(1可以改为你自己的基数) BEGIN INSERT b VALUES('1') END ELSE BEGIN UPDATE b SET b.xuhao=@i END END
CREATEA TRIGGER TEST ON TABLEA FOR UPDATE BEGIN IF UPDATE(字段) update tableb set 字段=b.字段 from inserted b END
FOR INSERT
BDGINdeclare @i int
select @i=id from inserted
insert into table(字段)
values(@i)END
--睡觉去了)
CREATE TRIGGER insert_trigger
ON a
FOR INSERT
AS
BEGIN
DECLARE @i int
SELECT @i=xuhao FROM inserted
IF @i=1 --(1可以改为你自己的基数)
BEGIN
INSERT b VALUES('1')
END
ELSE
BEGIN
UPDATE b
SET b.xuhao=@i
END
END
FOR UPDATE
BEGIN
IF UPDATE(字段)
update tableb set 字段=b.字段 from inserted b END
FOR INSERT
as
begin
declare @mid int
select @mid=id from inserted
insert table b set id= @mid
end