如插入 CREATE TRIGGER aa ON [dbo].[a] FOR INSERT AS insert into b(a,b,c) select a,b,c from inserted
Create trigger a_t on A for inert,update,delete as declare @a,@b,@c select @a=a,@b=b,@c=c from inserted if exists(select * from b where a=@a and b=@b and c=@c) update b..... if not exists(select * from b where a=@a and b=@b and c=@c) insert into b(a,b,c) values(@a,@b,@c) select @a=a,@b=b,@c=c from deleted delete from b where ....
To daijingjie2002(代京杰) 如果分開寫,你的這個trigger是對的
如插入 CREATE TRIGGER aa ON [dbo].[a] FOR INSERT AS insert into b(a,b,c) select a,b,c from inserted
如插入 CREATE TRIGGER aa ON [dbo].[a] FOR INSERT AS Declare @a varchar(10), @b 類形, @c 類形 select @a=a,@b=b,@c=c from inserted update b set a=@a ....
上面打錯了字 應改成 如更新的 CREATE TRIGGER aa ON [dbo].[a] FOR INSERT AS Declare @a varchar(10), @b 類形, @c 類形 select @a=a,@b=b,@c=c from inserted update b set a=@a ....
create trigger on 表 for detele as detele .......
Create trigger a_t on A for inert,update,delete as declare @a,@b,@c select @a=a,@b=b,@c=c from inserted if exists(select * from b where a=@a and b=@b and c=@c) update b..... if not exists(select * from b where a=@a and b=@b and c=@c) insert into b(a,b,c) values(@a,@b,@c) select @a=a,@b=b,@c=c from deleted delete from b where ....
CREATE TRIGGER aa ON [dbo].[a]
FOR INSERT
AS
insert into b(a,b,c) select a,b,c from inserted
on A
for inert,update,delete
as
declare @a,@b,@c
select @a=a,@b=b,@c=c from inserted
if exists(select * from b where a=@a and b=@b and c=@c)
update b.....
if not exists(select * from b where a=@a and b=@b and c=@c)
insert into b(a,b,c) values(@a,@b,@c)
select @a=a,@b=b,@c=c from deleted
delete from b where ....
如果分開寫,你的這個trigger是對的
CREATE TRIGGER aa ON [dbo].[a]
FOR INSERT
AS
insert into b(a,b,c) select a,b,c from inserted
CREATE TRIGGER aa ON [dbo].[a]
FOR INSERT
AS
Declare @a varchar(10),
@b 類形,
@c 類形
select @a=a,@b=b,@c=c from inserted
update b set a=@a ....
上面打錯了字
應改成
如更新的
CREATE TRIGGER aa ON [dbo].[a]
FOR INSERT
AS
Declare @a varchar(10),
@b 類形,
@c 類形
select @a=a,@b=b,@c=c from inserted
update b set a=@a ....
for detele
as
detele .......
on A
for inert,update,delete
as
declare @a,@b,@c
select @a=a,@b=b,@c=c from inserted
if exists(select * from b where a=@a and b=@b and c=@c)
update b.....
if not exists(select * from b where a=@a and b=@b and c=@c)
insert into b(a,b,c) values(@a,@b,@c)
select @a=a,@b=b,@c=c from deleted
delete from b where ....