sql server trigger

Insert：

USE [master]
GO
/****** 对象:  Trigger [Insert_A]    脚本日期: 09/26/2012 16:57:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE 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