USE [master]
GO
/****** 对象: Trigger [Insert_A] 脚本日期: 09/26/2012 16:57:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOCREATE trigger [Insert_A] on [dbo].[A]
for insert
as
begin
declare @id int
select @id = id from inserted
insert into B(id) values (@id)
end
Update:
USE [master]
GO
/****** 对象: Trigger [Update_A] 脚本日期: 09/26/2012 16:57:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create trigger [Update_A] on [dbo].[A]
after update
as
begin
declare @i int
declare @k int
select @i = id from Deleted
select @k = id from inserted
update B set id=@k where id=@i
end
Delete:
USE [master]
GO
/****** 对象: Trigger [Delete_A] 脚本日期: 09/26/2012 16:57:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create trigger [Delete_A] on [dbo].[A]
for delete
as
begin
declare @i int
select @i = id from Deleted
delete from B where id=@i
end