关于触发器,先弄个上来

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author:<Caceolod>
-- Create date: <2007-4-3>
-- Description: <删除帐号后，同步删除T_User和T_Admin中的信息>
-- =============================================
ALTER TRIGGER [Trigger_Membership_Delete]
   ON  [dbo].[aspnet_Membership]
   AFTER DELETE
AS
BEGIN 
 SET NOCOUNT ON;

 Declare @DeletedID uniqueidentifier;
 Select @DeletedID=UserID From Deleted;

 --删除T_User中的信息
 Delete From T_User Where F_ID=@DeletedID;

 --删除T_Admin中的信息
 Delete From T_Admin Where F_ID=@DeletedID;

 --删除T_Shop中的信息
 Delete From T_Shop Where F_ID=@DeletedID;

END